Pro*C precompiler<\/li>\n<\/ul>\n\ud658\uacbd \uc124\uc815\uc774 \uc644\ub8cc\ub418\uc5c8\ub2e4\uba74, Pro*C \uc18c\uc2a4\ub97c \uc791\uc131\ud560 \uc900\ube44\uac00 \ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n
3. \uccab \ubc88\uc9f8 Pro*C \ud504\ub85c\uadf8\ub7a8<\/h2>\n3.1 \uae30\ubcf8 \uc5f0\uacb0<\/h3>\n
\uc6b0\uc120 Oracle \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640\uc758 \uc5f0\uacb0\uc744 \uc124\uc815\ud574\uc57c \ud569\ub2c8\ub2e4. \ub2e4\uc74c\uc740 \uae30\ubcf8\uc801\uc778 \uc5f0\uacb0\uc744 \uc704\ud55c \ucf54\ub4dc \uc0d8\ud50c\uc785\ub2c8\ub2e4:<\/p>\n
\n#include <stdio.h>\n#include <stdlib.h>\n#include <sqlca.h> \/\/ SQLCA \uad6c\uc870\uccb4\ub97c \ud3ec\ud568\ud574\uc57c \ud568\n#include <sqlcpr.h> \/\/ SQL \uc2e4\ud589\uc744 \uc704\ud55c \ud5e4\ub354\n\nEXEC SQL BEGIN DECLARE SECTION;\nchar *username = \"your_username\"; \/\/ \uc0ac\uc6a9\uc790 \uc774\ub984\nchar *password = \"your_password\"; \/\/ \ube44\ubc00\ubc88\ud638\nchar *db = \"your_db\"; \/\/ \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc774\ub984\nEXEC SQL END DECLARE SECTION;\n\nint main() {\n \/\/ Oracle \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc5f0\uacb0\n EXEC SQL CONNECT :username IDENTIFIED BY :password USING :db;\n\n if (sqlca.sqlcode != 0) {\n printf(\"\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5f0\uacb0 \uc2e4\ud328: %d\\n\", sqlca.sqlcode);\n return 1;\n }\n printf(\"\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc131\uacf5\uc801\uc73c\ub85c \uc5f0\uacb0\ub418\uc5c8\uc2b5\ub2c8\ub2e4.\\n\");\n\n \/\/ \uc5f0\uacb0 \uc885\ub8cc\n EXEC SQL COMMIT WORK RELEASE;\n\n return 0;\n}\n <\/code><\/pre>\n3.2 \uac04\ub2e8\ud55c SELECT \ubb38 \uc2e4\ud589<\/h3>\n
\uc5f0\uacb0\uc774 \uc131\uacf5\uc801\uc73c\ub85c \uc774\ub8e8\uc5b4\uc9c4 \ud6c4, \uac04\ub2e8\ud55c SELECT \ubb38\uc744 \uc2e4\ud589\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, EMPLOYEES \ud14c\uc774\ube14\uc5d0\uc11c \uc9c1\uc6d0\uc758 \uc774\ub984\uacfc \uae09\uc5ec\ub97c \uc870\ud68c\ud558\ub294 \ud504\ub85c\uadf8\ub7a8\uc774 \uc788\uc2b5\ub2c8\ub2e4:<\/p>\n
\n#include <stdio.h>\n#include <stdlib.h>\n#include <sqlca.h>\n#include <sqlcpr.h>\n\nEXEC SQL BEGIN DECLARE SECTION;\nchar *username = \"your_username\"; \/\/ \uc0ac\uc6a9\uc790 \uc774\ub984\nchar *password = \"your_password\"; \/\/ \ube44\ubc00\ubc88\ud638\nchar *db = \"your_db\"; \/\/ \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc774\ub984\nchar employee_name[50]; \/\/ \uc9c1\uc6d0 \uc774\ub984\ndouble salary; \/\/ \uae09\uc5ec\nEXEC SQL END DECLARE SECTION;\n\nint main() {\n \/\/ \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc5f0\uacb0\n EXEC SQL CONNECT :username IDENTIFIED BY :password USING :db;\n\n if (sqlca.sqlcode != 0) {\n printf(\"\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5f0\uacb0 \uc2e4\ud328: %d\\n\", sqlca.sqlcode);\n return 1;\n }\n\n \/\/ SELECT \ubb38 \uc2e4\ud589\n EXEC SQL SELECT name, salary INTO :employee_name, :salary FROM EMPLOYEES WHERE ROWNUM = 1;\n\n if (sqlca.sqlcode == 0) {\n printf(\"\uc9c1\uc6d0 \uc774\ub984: %s, \uae09\uc5ec: %.2f\\n\", employee_name, salary);\n } else {\n printf(\"\uc870\ud68c \uc2e4\ud328: %d\\n\", sqlca.sqlcode);\n }\n\n \/\/ \uc5f0\uacb0 \uc885\ub8cc\n EXEC SQL COMMIT WORK RELEASE;\n\n return 0;\n}\n <\/code><\/pre>\n3.3 \uacb0\uacfc \ucd9c\ub825<\/h3>\n
\uc704\uc758 SELECT \ubb38\uc740 EMPLOYEES \ud14c\uc774\ube14\uc5d0\uc11c \uccab \ubc88\uc9f8 \uc9c1\uc6d0\uc758 \uc774\ub984\uacfc \uae09\uc5ec\ub97c \ucd9c\ub825\ud569\ub2c8\ub2e4. \uacb0\uacfc\uac00 \uc131\uacf5\uc801\uc73c\ub85c \ucd9c\ub825\ub418\uba74 \uacbd\uacfc\ub41c \uc2dc\uac04\uc774 \uc544\ub2cc \ub2e4\ub978 \uc815\ubcf4\ub97c \ucd94\uac00\ub85c \ucd9c\ub825\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \uc544\ub798\uc640 \uac19\uc774 \ucffc\ub9ac\ub97c \uc218\uc815\ud558\uc5ec \uc804\uccb4 \uc9c1\uc6d0 \ubaa9\ub85d\uc744 \ucd9c\ub825\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4:<\/p>\n
\n#include <stdio.h>\n#include <stdlib.h>\n#include <sqlca.h>\n#include <sqlcpr.h>\n\nEXEC SQL BEGIN DECLARE SECTION;\nchar *username = \"your_username\"; \/\/ \uc0ac\uc6a9\uc790 \uc774\ub984\nchar *password = \"your_password\"; \/\/ \ube44\ubc00\ubc88\ud638\nchar *db = \"your_db\"; \/\/ \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc774\ub984\nchar employee_name[50]; \/\/ \uc9c1\uc6d0 \uc774\ub984\ndouble salary; \/\/ \uae09\uc5ec\nEXEC SQL END DECLARE SECTION;\n\nint main() {\n \/\/ \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc5f0\uacb0\n EXEC SQL CONNECT :username IDENTIFIED BY :password USING :db;\n\n if (sqlca.sqlcode != 0) {\n printf(\"\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5f0\uacb0 \uc2e4\ud328: %d\\n\", sqlca.sqlcode);\n return 1;\n }\n\n \/\/ \uacb0\uacfc \uc9d1\ud569\uc744 \uc800\uc7a5\ud558\uae30 \uc704\ud55c \ucee4\uc11c \uc120\uc5b8\n EXEC SQL DECLARE emp_cursor CURSOR FOR\n SELECT name, salary FROM EMPLOYEES;\n\n \/\/ \ucee4\uc11c \uc5f4\uae30\n EXEC SQL OPEN emp_cursor;\n\n \/\/ \uacb0\uacfc \uc9d1\ud569\uc744 \uc21c\ud68c\ud558\uba70 \ucd9c\ub825\n while (1) {\n EXEC SQL FETCH emp_cursor INTO :employee_name, :salary;\n if (sqlca.sqlcode != 0) break; \/\/ \ub354 \uc774\uc0c1\uc758 \ub370\uc774\ud130\uac00 \uc5c6\uc73c\uba74 \uc885\ub8cc\n printf(\"\uc9c1\uc6d0 \uc774\ub984: %s, \uae09\uc5ec: %.2f\\n\", employee_name, salary);\n }\n\n printf(\"\ubaa8\ub4e0 \uc9c1\uc6d0 \uc815\ubcf4 \ucd9c\ub825 \uc644\ub8cc.\\n\");\n\n \/\/ \ucee4\uc11c \ub2eb\uae30\n EXEC SQL CLOSE emp_cursor;\n\n \/\/ \uc5f0\uacb0 \uc885\ub8cc\n EXEC SQL COMMIT WORK RELEASE;\n\n return 0;\n}\n <\/code><\/pre>\n4. \uc608\uc81c \uc2e4\ud589 \ubc29\ubc95<\/h2>\n
\uc720\ub2c9\uc2a4 \uacc4\uc5f4 OS\uc758 \uacbd\uc6b0 \ub2e4\uc74c\uacfc \uac19\uc740 \uba85\ub839\uc5b4\ub97c \ud1b5\ud574\uc11c Pro*C \ud504\ub85c\uadf8\ub7a8\uc744 \ucef4\ud30c\uc77c\ud558\uace0 \uc2e4\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4:<\/p>\n
\n- Pro*C \ucef4\ud30c\uc77c\ub7ec\ub97c \uc0ac\uc6a9\ud558\uc5ec SQL \ubb38\uc774 \ud3ec\ud568\ub41c \uc18c\uc2a4\ub97c \ucc98\ub9ac\ud569\ub2c8\ub2e4:
proc iname=your_program.pc<\/code><\/li>\n- \uc0dd\uc131\ub41c C \uc18c\uc2a4\ub97c \ucef4\ud30c\uc77c\ud569\ub2c8\ub2e4:
gcc your_program.c -o your_program -I$ORACLE_HOME\/rdbms\/public -L$ORACLE_HOME\/lib -lclntsh<\/code><\/li>\n- \ud504\ub85c\uadf8\ub7a8\uc744 \uc2e4\ud589\ud569\ub2c8\ub2e4:
.\/your_program<\/code><\/li>\n<\/ol>\n5. \ub9c8\ubb34\ub9ac<\/h2>\n
\uc774\uae00\uc5d0\uc11c\ub294 Pro*C\uc758 \uae30\ubcf8\uc801\uc778 \uc0ac\uc6a9\ubc95\uc744 \uc124\uba85\ud588\uc2b5\ub2c8\ub2e4. Oracle \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640\uc758 \uc5f0\uacb0, \uac04\ub2e8\ud55c SQL \ucffc\ub9ac \uc2e4\ud589, \uadf8\ub9ac\uace0 \uacb0\uacfc \ucd9c\ub825\uae4c\uc9c0\uc758 \uacfc\uc815\uc774 \ud3ec\ud568\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. Pro*C\ub294 \uac15\ub825\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud504\ub85c\uadf8\ub798\ubc0d \ub3c4\uad6c\uc774\ubbc0\ub85c \ubcf5\uc7a1\ud55c \ube44\uc988\ub2c8\uc2a4 \ub85c\uc9c1\uc744 \uad6c\ud604\ud558\ub294 \ub370 \uc720\uc6a9\ud569\ub2c8\ub2e4. \ub354 \uae4a\uc774 \uc788\ub294 \uae30\ub2a5\uc774\ub098 \ubcf5\uc7a1\ud55c \uc608\uc81c\ub294 Oracle \uacf5\uc2dd \ubb38\uc11c\ub098 Pro*C \uad00\ub828 \uc790\ub8cc\ub4e4\uc744 \ud1b5\ud574 \ucc3e\uc544\ubcf4\uae38 \uad8c\uc7a5\ud569\ub2c8\ub2e4.<\/p>\n<\/article>\n
<\/body><\/p>\n","protected":false},"excerpt":{"rendered":"
Pro*C\ub294 Oracle\uc758 C \uae30\ubc18\uc758 \ud504\ub85c\uadf8\ub798\ubc0d \uc5b8\uc5b4\ub85c, \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640\uc758 \uc0c1\ud638\uc791\uc6a9\uc744 \ub9e4\uc6b0 \ud6a8\uc728\uc801\uc73c\ub85c \uc218\ud589\ud560 \uc218 \uc788\ub3c4\ub85d \ub3d5\uc2b5\ub2c8\ub2e4. \uc774 \uae00\uc5d0\uc11c\ub294 Pro*C \ud504\ub85c\uadf8\ub7a8\uc758 \uae30\ubcf8\uc801\uc778 \uc124\uc815, \uac04\ub2e8\ud55c SELECT \ucffc\ub9ac \uc2e4\ud589, \uadf8\ub9ac\uace0 \uacb0\uacfc \ucd9c\ub825\uc744 \ub2e4\ub8f0 \uac83\uc785\ub2c8\ub2e4. 1. Pro*C \uc18c\uac1c Pro*C\ub294 Oracle \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 C\uc5b8\uc5b4 \uac04\uc758 \uc778\ud130\ud398\uc774\uc2a4\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc774\ub294 C \ud504\ub85c\uadf8\ub7a8 \ub0b4\uc5d0\uc11c SQL \ucffc\ub9ac\ub97c \uc791\uc131\ud558\uace0 \uc2e4\ud589\ud560 \uc218 \uc788\uac8c \ub3c4\uc640\uc90d\ub2c8\ub2e4. Pro*C \ud504\ub85c\uadf8\ub7a8\uc740 \uc77c\ubc18 C \ud504\ub85c\uadf8\ub7a8\uacfc … \ub354 \ubcf4\uae30 “3.\uccab \ubc88\uc9f8 Pro C \ud504\ub85c\uadf8\ub7a8 \uc791\uc131\ud558\uae30, \ub0b4\uc6a9 \uae30\ubcf8 \uc5f0\uacb0, \uac04\ub2e8\ud55c SELECT \ubb38 \uc2e4\ud589, \uacb0\uacfc \ucd9c\ub825.”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[239],"tags":[],"class_list":["post-42555","post","type-post","status-publish","format-standard","hentry","category-proc"],"yoast_head":"\n3.\uccab \ubc88\uc9f8 Pro C \ud504\ub85c\uadf8\ub7a8 \uc791\uc131\ud558\uae30, \ub0b4\uc6a9 \uae30\ubcf8 \uc5f0\uacb0, \uac04\ub2e8\ud55c SELECT \ubb38 \uc2e4\ud589, \uacb0\uacfc \ucd9c\ub825. - \ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/atmokpo.com\/w\/42555\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"3.\uccab \ubc88\uc9f8 Pro C \ud504\ub85c\uadf8\ub7a8 \uc791\uc131\ud558\uae30, \ub0b4\uc6a9 \uae30\ubcf8 \uc5f0\uacb0, \uac04\ub2e8\ud55c SELECT \ubb38 \uc2e4\ud589, \uacb0\uacfc \ucd9c\ub825. - \ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8\" \/>\n<meta property=\"og:description\" content=\"Pro*C\ub294 Oracle\uc758 C \uae30\ubc18\uc758 \ud504\ub85c\uadf8\ub798\ubc0d \uc5b8\uc5b4\ub85c, \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640\uc758 \uc0c1\ud638\uc791\uc6a9\uc744 \ub9e4\uc6b0 \ud6a8\uc728\uc801\uc73c\ub85c \uc218\ud589\ud560 \uc218 \uc788\ub3c4\ub85d \ub3d5\uc2b5\ub2c8\ub2e4. \uc774 \uae00\uc5d0\uc11c\ub294 Pro*C \ud504\ub85c\uadf8\ub7a8\uc758 \uae30\ubcf8\uc801\uc778 \uc124\uc815, \uac04\ub2e8\ud55c SELECT \ucffc\ub9ac \uc2e4\ud589, \uadf8\ub9ac\uace0 \uacb0\uacfc \ucd9c\ub825\uc744 \ub2e4\ub8f0 \uac83\uc785\ub2c8\ub2e4. 1. Pro*C \uc18c\uac1c Pro*C\ub294 Oracle \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 C\uc5b8\uc5b4 \uac04\uc758 \uc778\ud130\ud398\uc774\uc2a4\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc774\ub294 C \ud504\ub85c\uadf8\ub7a8 \ub0b4\uc5d0\uc11c SQL \ucffc\ub9ac\ub97c \uc791\uc131\ud558\uace0 \uc2e4\ud589\ud560 \uc218 \uc788\uac8c \ub3c4\uc640\uc90d\ub2c8\ub2e4. Pro*C \ud504\ub85c\uadf8\ub7a8\uc740 \uc77c\ubc18 C \ud504\ub85c\uadf8\ub7a8\uacfc … \ub354 \ubcf4\uae30 "3.\uccab \ubc88\uc9f8 Pro C \ud504\ub85c\uadf8\ub7a8 \uc791\uc131\ud558\uae30, \ub0b4\uc6a9 \uae30\ubcf8 \uc5f0\uacb0, \uac04\ub2e8\ud55c SELECT \ubb38 \uc2e4\ud589, \uacb0\uacfc \ucd9c\ub825."\" \/>\n<meta property=\"og:url\" content=\"https:\/\/atmokpo.com\/w\/42555\/\" \/>\n<meta property=\"og:site_name\" content=\"\ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8\" \/>\n<meta property=\"article:published_time\" content=\"2024-11-11T03:00:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-26T06:35:07+00:00\" \/>\n<meta name=\"author\" content=\"root\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@bebubo4\" \/>\n<meta name=\"twitter:site\" content=\"@bebubo4\" \/>\n<meta name=\"twitter:label1\" content=\"\uae00\uc4f4\uc774\" \/>\n\t<meta name=\"twitter:data1\" content=\"root\" \/>\n\t<meta name=\"twitter:label2\" content=\"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04\" \/>\n\t<meta name=\"twitter:data2\" content=\"2\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/atmokpo.com\/w\/42555\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/atmokpo.com\/w\/42555\/\"},\"author\":{\"name\":\"root\",\"@id\":\"https:\/\/atmokpo.com\/w\/#\/schema\/person\/91b6b3b138fbba0efb4ae64b1abd81d7\"},\"headline\":\"3.\uccab \ubc88\uc9f8 Pro C \ud504\ub85c\uadf8\ub7a8 \uc791\uc131\ud558\uae30, \ub0b4\uc6a9 \uae30\ubcf8 \uc5f0\uacb0, \uac04\ub2e8\ud55c SELECT \ubb38 \uc2e4\ud589, \uacb0\uacfc \ucd9c\ub825.\",\"datePublished\":\"2024-11-11T03:00:30+00:00\",\"dateModified\":\"2024-11-26T06:35:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/atmokpo.com\/w\/42555\/\"},\"wordCount\":58,\"publisher\":{\"@id\":\"https:\/\/atmokpo.com\/w\/#organization\"},\"articleSection\":[\"proc\"],\"inLanguage\":\"ko-KR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/atmokpo.com\/w\/42555\/\",\"url\":\"https:\/\/atmokpo.com\/w\/42555\/\",\"name\":\"3.\uccab \ubc88\uc9f8 Pro C \ud504\ub85c\uadf8\ub7a8 \uc791\uc131\ud558\uae30, \ub0b4\uc6a9 \uae30\ubcf8 \uc5f0\uacb0, \uac04\ub2e8\ud55c SELECT \ubb38 \uc2e4\ud589, \uacb0\uacfc \ucd9c\ub825. - \ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8\",\"isPartOf\":{\"@id\":\"https:\/\/atmokpo.com\/w\/#website\"},\"datePublished\":\"2024-11-11T03:00:30+00:00\",\"dateModified\":\"2024-11-26T06:35:07+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/atmokpo.com\/w\/42555\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/atmokpo.com\/w\/42555\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/atmokpo.com\/w\/42555\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\ud648\",\"item\":\"https:\/\/atmokpo.com\/w\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"3.\uccab \ubc88\uc9f8 Pro C \ud504\ub85c\uadf8\ub7a8 \uc791\uc131\ud558\uae30, \ub0b4\uc6a9 \uae30\ubcf8 \uc5f0\uacb0, \uac04\ub2e8\ud55c SELECT \ubb38 \uc2e4\ud589, \uacb0\uacfc \ucd9c\ub825.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/atmokpo.com\/w\/#website\",\"url\":\"https:\/\/atmokpo.com\/w\/\",\"name\":\"\ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/atmokpo.com\/w\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/atmokpo.com\/w\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/atmokpo.com\/w\/#organization\",\"name\":\"\ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8\",\"url\":\"https:\/\/atmokpo.com\/w\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/atmokpo.com\/w\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/atmokpo.com\/w\/wp-content\/uploads\/2024\/11\/logo.png\",\"contentUrl\":\"https:\/\/atmokpo.com\/w\/wp-content\/uploads\/2024\/11\/logo.png\",\"width\":400,\"height\":400,\"caption\":\"\ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8\"},\"image\":{\"@id\":\"https:\/\/atmokpo.com\/w\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/bebubo4\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/atmokpo.com\/w\/#\/schema\/person\/91b6b3b138fbba0efb4ae64b1abd81d7\",\"name\":\"root\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/atmokpo.com\/w\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/708197b41fc6435a7ce22d951b25d4a47e9e904270cb1f04682d4f025066f80c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/708197b41fc6435a7ce22d951b25d4a47e9e904270cb1f04682d4f025066f80c?s=96&d=mm&r=g\",\"caption\":\"root\"},\"sameAs\":[\"http:\/\/atmokpo.com\/w\"],\"url\":\"https:\/\/atmokpo.com\/w\/author\/root\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"3.\uccab \ubc88\uc9f8 Pro C \ud504\ub85c\uadf8\ub7a8 \uc791\uc131\ud558\uae30, \ub0b4\uc6a9 \uae30\ubcf8 \uc5f0\uacb0, \uac04\ub2e8\ud55c SELECT \ubb38 \uc2e4\ud589, \uacb0\uacfc \ucd9c\ub825. - \ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/atmokpo.com\/w\/42555\/","og_locale":"ko_KR","og_type":"article","og_title":"3.\uccab \ubc88\uc9f8 Pro C \ud504\ub85c\uadf8\ub7a8 \uc791\uc131\ud558\uae30, \ub0b4\uc6a9 \uae30\ubcf8 \uc5f0\uacb0, \uac04\ub2e8\ud55c SELECT \ubb38 \uc2e4\ud589, \uacb0\uacfc \ucd9c\ub825. - \ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8","og_description":"Pro*C\ub294 Oracle\uc758 C \uae30\ubc18\uc758 \ud504\ub85c\uadf8\ub798\ubc0d \uc5b8\uc5b4\ub85c, \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640\uc758 \uc0c1\ud638\uc791\uc6a9\uc744 \ub9e4\uc6b0 \ud6a8\uc728\uc801\uc73c\ub85c \uc218\ud589\ud560 \uc218 \uc788\ub3c4\ub85d \ub3d5\uc2b5\ub2c8\ub2e4. \uc774 \uae00\uc5d0\uc11c\ub294 Pro*C \ud504\ub85c\uadf8\ub7a8\uc758 \uae30\ubcf8\uc801\uc778 \uc124\uc815, \uac04\ub2e8\ud55c SELECT \ucffc\ub9ac \uc2e4\ud589, \uadf8\ub9ac\uace0 \uacb0\uacfc \ucd9c\ub825\uc744 \ub2e4\ub8f0 \uac83\uc785\ub2c8\ub2e4. 1. Pro*C \uc18c\uac1c Pro*C\ub294 Oracle \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 C\uc5b8\uc5b4 \uac04\uc758 \uc778\ud130\ud398\uc774\uc2a4\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc774\ub294 C \ud504\ub85c\uadf8\ub7a8 \ub0b4\uc5d0\uc11c SQL \ucffc\ub9ac\ub97c \uc791\uc131\ud558\uace0 \uc2e4\ud589\ud560 \uc218 \uc788\uac8c \ub3c4\uc640\uc90d\ub2c8\ub2e4. Pro*C \ud504\ub85c\uadf8\ub7a8\uc740 \uc77c\ubc18 C \ud504\ub85c\uadf8\ub7a8\uacfc … \ub354 \ubcf4\uae30 \"3.\uccab \ubc88\uc9f8 Pro C \ud504\ub85c\uadf8\ub7a8 \uc791\uc131\ud558\uae30, \ub0b4\uc6a9 \uae30\ubcf8 \uc5f0\uacb0, \uac04\ub2e8\ud55c SELECT \ubb38 \uc2e4\ud589, \uacb0\uacfc \ucd9c\ub825.\"","og_url":"https:\/\/atmokpo.com\/w\/42555\/","og_site_name":"\ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8","article_published_time":"2024-11-11T03:00:30+00:00","article_modified_time":"2024-11-26T06:35:07+00:00","author":"root","twitter_card":"summary_large_image","twitter_creator":"@bebubo4","twitter_site":"@bebubo4","twitter_misc":{"\uae00\uc4f4\uc774":"root","\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04":"2\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/atmokpo.com\/w\/42555\/#article","isPartOf":{"@id":"https:\/\/atmokpo.com\/w\/42555\/"},"author":{"name":"root","@id":"https:\/\/atmokpo.com\/w\/#\/schema\/person\/91b6b3b138fbba0efb4ae64b1abd81d7"},"headline":"3.\uccab \ubc88\uc9f8 Pro C \ud504\ub85c\uadf8\ub7a8 \uc791\uc131\ud558\uae30, \ub0b4\uc6a9 \uae30\ubcf8 \uc5f0\uacb0, \uac04\ub2e8\ud55c SELECT \ubb38 \uc2e4\ud589, \uacb0\uacfc \ucd9c\ub825.","datePublished":"2024-11-11T03:00:30+00:00","dateModified":"2024-11-26T06:35:07+00:00","mainEntityOfPage":{"@id":"https:\/\/atmokpo.com\/w\/42555\/"},"wordCount":58,"publisher":{"@id":"https:\/\/atmokpo.com\/w\/#organization"},"articleSection":["proc"],"inLanguage":"ko-KR"},{"@type":"WebPage","@id":"https:\/\/atmokpo.com\/w\/42555\/","url":"https:\/\/atmokpo.com\/w\/42555\/","name":"3.\uccab \ubc88\uc9f8 Pro C \ud504\ub85c\uadf8\ub7a8 \uc791\uc131\ud558\uae30, \ub0b4\uc6a9 \uae30\ubcf8 \uc5f0\uacb0, \uac04\ub2e8\ud55c SELECT \ubb38 \uc2e4\ud589, \uacb0\uacfc \ucd9c\ub825. - \ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8","isPartOf":{"@id":"https:\/\/atmokpo.com\/w\/#website"},"datePublished":"2024-11-11T03:00:30+00:00","dateModified":"2024-11-26T06:35:07+00:00","breadcrumb":{"@id":"https:\/\/atmokpo.com\/w\/42555\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/atmokpo.com\/w\/42555\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/atmokpo.com\/w\/42555\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\ud648","item":"https:\/\/atmokpo.com\/w\/en\/"},{"@type":"ListItem","position":2,"name":"3.\uccab \ubc88\uc9f8 Pro C \ud504\ub85c\uadf8\ub7a8 \uc791\uc131\ud558\uae30, \ub0b4\uc6a9 \uae30\ubcf8 \uc5f0\uacb0, \uac04\ub2e8\ud55c SELECT \ubb38 \uc2e4\ud589, \uacb0\uacfc \ucd9c\ub825."}]},{"@type":"WebSite","@id":"https:\/\/atmokpo.com\/w\/#website","url":"https:\/\/atmokpo.com\/w\/","name":"\ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8","description":"","publisher":{"@id":"https:\/\/atmokpo.com\/w\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/atmokpo.com\/w\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Organization","@id":"https:\/\/atmokpo.com\/w\/#organization","name":"\ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8","url":"https:\/\/atmokpo.com\/w\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/atmokpo.com\/w\/#\/schema\/logo\/image\/","url":"https:\/\/atmokpo.com\/w\/wp-content\/uploads\/2024\/11\/logo.png","contentUrl":"https:\/\/atmokpo.com\/w\/wp-content\/uploads\/2024\/11\/logo.png","width":400,"height":400,"caption":"\ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8"},"image":{"@id":"https:\/\/atmokpo.com\/w\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/bebubo4"]},{"@type":"Person","@id":"https:\/\/atmokpo.com\/w\/#\/schema\/person\/91b6b3b138fbba0efb4ae64b1abd81d7","name":"root","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/atmokpo.com\/w\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/708197b41fc6435a7ce22d951b25d4a47e9e904270cb1f04682d4f025066f80c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/708197b41fc6435a7ce22d951b25d4a47e9e904270cb1f04682d4f025066f80c?s=96&d=mm&r=g","caption":"root"},"sameAs":["http:\/\/atmokpo.com\/w"],"url":"https:\/\/atmokpo.com\/w\/author\/root\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/atmokpo.com\/w\/wp-json\/wp\/v2\/posts\/42555","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/atmokpo.com\/w\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/atmokpo.com\/w\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/atmokpo.com\/w\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/atmokpo.com\/w\/wp-json\/wp\/v2\/comments?post=42555"}],"version-history":[{"count":1,"href":"https:\/\/atmokpo.com\/w\/wp-json\/wp\/v2\/posts\/42555\/revisions"}],"predecessor-version":[{"id":42556,"href":"https:\/\/atmokpo.com\/w\/wp-json\/wp\/v2\/posts\/42555\/revisions\/42556"}],"wp:attachment":[{"href":"https:\/\/atmokpo.com\/w\/wp-json\/wp\/v2\/media?parent=42555"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/atmokpo.com\/w\/wp-json\/wp\/v2\/categories?post=42555"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/atmokpo.com\/w\/wp-json\/wp\/v2\/tags?post=42555"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}