{"id":510,"date":"2015-02-11T18:29:42","date_gmt":"2015-02-12T03:29:42","guid":{"rendered":"\/blog\/?p=510"},"modified":"2023-09-21T09:38:41","modified_gmt":"2023-09-21T00:38:41","slug":"oracle-proc-%ec%86%8c%ea%b0%9c%ec%99%80-%ea%b8%b0%eb%b3%b8-%ed%8a%b9%ec%a7%95","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=510","title":{"rendered":"Oracle Pro*C \uc18c\uac1c\uc640 \uae30\ubcf8 \ud2b9\uc9d5"},"content":{"rendered":"\n<p><span style=\"COLOR: rgb(153,0,133)\"><span style=\"FONT-WEIGHT: bold\"><span style=\"FONT-SIZE: 11pt\"><span style=\"font-size: 8pt; font-family: Dotum,\ub3cb\uc6c0;\">\ucd9c\ucc98 : <\/span><a class=\"tx-link\" target=\"_blank\" href=\"http:\/\/blog.daum.net\/miracle_jhw\/14\" rel=\"noopener\"><span style=\"font-size: 8pt; font-family: Dotum,\ub3cb\uc6c0;\">http:\/\/blog.daum.net\/miracle_jhw\/14<\/span><\/a><br \/><\/span><\/span><\/span><\/p><p><span style=\"COLOR: rgb(153,0,133)\"><span style=\"FONT-WEIGHT: bold\"><span style=\"FONT-SIZE: 11pt\"><br \/><\/span><\/span><\/span><\/p><p><span style=\"COLOR: rgb(153,0,133)\"><span style=\"FONT-WEIGHT: bold\"><span style=\"FONT-SIZE: 11pt\">1\uc7a5. &nbsp;Pro*C \uc18c\uac1c\uc640 \uae30\ubcf8 \ud2b9\uc9d5<\/span><\/span><\/span><\/p>\n<p style=\"MARGIN-LEFT: 4em\"><br \/><\/p>\n<p style=\"MARGIN-LEFT: 4em\"><span style=\"COLOR: rgb(153,0,133)\"><span style=\"FONT-SIZE: 10pt\">1-1. Pro*C \uac1c\uc694<\/span><\/span><\/p><p style=\"MARGIN-LEFT: 4em\"><span style=\"COLOR: rgb(153,0,133)\"><span style=\"FONT-SIZE: 10pt\"><br \/><\/span><\/span><\/p>\n<p style=\"MARGIN-LEFT: 8em\"><span style=\"font-size:9pt;\"><span style=\"COLOR: rgb(0,0,0)\">SQL \ubb38\uc740 \uc808\ucc28\ud615 \uc5b8\uc5b4\uac00 \uc544\ub2c8\ub2e4. \uadf8\ub798\uc11c \uc624\ub77c\ud074\uc744 \ud3ec\ud568\ud55c \ub9ce\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 PL\/SQL\uc774\ub77c\ub294 \uc808\ucc28\ud615 \uc5b8\uc5b4\ub97c \uc81c\uacf5\ud55c\ub2e4.<\/span><\/span><\/p>\n<p style=\"MARGIN-LEFT: 8em\"><span style=\"COLOR: rgb(0,0,0)\">DBMS\uc758 \ubc84\uc804\uc774 \n\ub192\uc544\uc9c0\uba74\uc11c \uc774\uc804\uacfc \ub2e4\ub974\uac8c PL\/SQL\uc5d0\ub3c4 \ub2e4\uc591\ud55c \uae30\ub2a5\uc774 \ucd94\uac00\ub418\uc5c8\ub2e4. \uc608\ub97c \ub4e4\uba74, TCP\/IP, HTTP, FILE I\/O \ub4f1\uacfc \n\uac19\uc740 \uae30\ub2a5\uc774 \ucd94\uac00\ub418\uc5b4 \ub2e4\uc591\ud55c \ubc29\uc2dd\uc758 \ud504\ub85c\uadf8\ub798\ubc0d\uc774 \uac00\ub2a5\ud574\uc84c\ub2e4. \ud558\uc9c0\ub9cc \uc624\ub77c\ud074 \uc678\ubd80 \ud504\ub85c\uadf8\ub7a8\uacfc\uc758 \uc5f0\ub3d9 \ub4f1\uc5d0 \uc788\uc5b4\uc11c \ub9ce\uc740 \uc81c\uc57d\uc774 \n\uc788\ub294\ub370, \uc774\ub7f0 \uc81c\uc57d\uc744 \ud574\uacb0\ud558\uae30 \uc704\ud574\uc11c \ub300\ubd80\ubd84\uc758 DBMS \ubca4\ub354\ub294 \uc678\ubd80 C \ud504\ub85c\uadf8\ub7a8\uacfc \uacb0\ud569\ud560 \uc218 \uc788\ub294 \uc120\ud589 \ucef4\ud30c\uc77c\ub7ec\ub97c \uc81c\uacf5\ud558\uace0 \uc788\uc73c\uba70\n \uc624\ub77c\ud074\uc5d0\uc11c\ub294 \uc774\ub97c<\/span><span style=\"COLOR: rgb(255,0,0)\"> Pro*C<\/span><span style=\"COLOR: rgb(0,0,0)\">\ub77c\uace0 \ud55c\ub2e4.<\/span><\/p>\n<p style=\"MARGIN-LEFT: 12em\">&nbsp;<\/p>\n<p><span style=\"COLOR: rgb(76,76,76)\"><span style=\"FONT-STYLE: italic\"><br \/><\/span><\/span><\/p>\n<p style=\"MARGIN-LEFT: 12em\"><span style=\"color: rgb(76, 76, 76); \">PL\/SQL(Procedural\n Language\/Structured Query Language)\uc774\ub780? &nbsp;:&nbsp;\uc624\ub77c\ud074 DBMS\uc5d0 \uc758\ud574 \uc2e4\ud589\ub418\ub294 \ud2b8\ub9ac\uac70\ub098 \ucd95\uc801 \uc808\ucc28 \n\ub4f1\uc744 \uc791\uc131\ud558\uae30 \uc704\ud574 \uc0ac\uc6a9\ub418\ub294 \uc624\ub77c\ud074\uc758 \ud504\ub85c\uadf8\ub798\ubc0d \uc5b8\uc5b4\uc774\ub2e4. \uc774\uac83\uc740 \ub610\ud55c SQL \uc9c8\uc758\uc5d0 \uc758\ud574 \ubc18\ud658\ub41c \ub370\uc774\ud130\uc5d0 \ub300\ud574, \uc815\ub82c \ub4f1\uc758 \n\ucc98\ub9ac\ub97c \ud558\uae30 \uc704\ud574 \uc0ac\uc6a9\ub418\uae30\ub3c4 \ud55c\ub2e4. PL\/SQL \ud504\ub85c\uadf8\ub7a8\uc740 \uc120\uc5b8\ubd80, \uc2e4\ud589\uba85\ub839\uc5b4\ub4e4, \uadf8\ub9ac\uace0 \uc608\uc678\ucc98\ub9ac \ubd80\ubd84 \ub4f1\uc73c\ub85c \uad6c\uc131\ub418\ub294, \ud558\ub098\uc758 \n\ube14\ub85d\uc73c\ub85c \uad6c\uc870\ud654\ub418\uc5b4 \uc788\ub2e4.<\/span><\/p>\n<p><span style=\"font-style: italic;\">&nbsp;<\/span><\/p>\n<p style=\"MARGIN-LEFT: 12em\"><span style=\"color: rgb(76, 76, 76); \">DBMS(DataBase Management System)\ub780? : \ub2e4\uc218\uc758 \ucef4\ud4e8\ud130 \uc0ac\uc6a9\uc790\ub4e4\uc774 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc548\uc5d0 \ub370\uc774\ud130\ub97c \uae30\ub85d\ud558\uac70\ub098 \uc811\uadfc\ud560 \uc218 \uc788\ub610\ub85d \ud574\uc8fc\ub294 \ud504\ub85c\uadf8\ub7a8\uc774\ub2e4.<\/span><\/p>\n<p style=\"MARGIN-LEFT: 12em\"><span style=\"color: rgb(76, 76, 76); font-style: italic;\"><br \/><\/span><\/p>\n<p style=\"MARGIN-LEFT: 12em\"><span style=\"color: rgb(76, 76, 76); \">TCP\/IP(Transmission\n Control Protocol\/Internet Prorocol)\ub780? : \uc778\ud130\ub137\uc758 \uae30\ubcf8\uc801\uc778 \ud1b5\uc2e0 \ud504\ub85c\ud1a0\ucf5c\ub85c\uc11c, \uc778\ud2b8\ub77c\ub137\uc774\ub098 \n\uc5d1\uc2a4\ud2b8\ub77c\ub137\uacfc \uac19\uc740 \uc0ac\uc124 \ub9dd\uc5d0\uc11c\ub3c4 \uc0ac\uc6a9\ub41c\ub2e4. \uc0ac\uc6a9\uc790\uac00 \uc778\ud130\ub137\uc5d0 \uc811\uc18d\ud558\uae30 \uc704\ud574 \uc790\uc2e0\uc758 \ucef4\ud4e8\ud130\ub97c \uc124\uc815\ud560 \ub54c TCP\/IP \ud504\ub85c\uadf8\ub7a8\uc774 \n\uc124\uce58\ub418\uba70, \uc774\ub97c \ud1b5\ud558\uc5ec \uc5ed\uc2dc \uac19\uc740 TCP\/IP \ud504\ub85c\ud1a0\ucf5c\uc744 \uc4f0\uace0 \uc788\ub294 \ub2e4\ub978 \ucef4\ud4e8\ud130 \uc0ac\uc6a9\uc790\uc640 \uba54\uc2dc\uc9c0\ub97c \uc8fc\uace0\ubc1b\uac70\ub098, \ub610\ub294 \uc815\ubcf4\ub97c \uc5bb\uc744 \uc218\n \uc788\uac8c \ub41c\ub2e4.<\/span><\/p>\n<p style=\"MARGIN-LEFT: 12em\"><span style=\"color: rgb(76, 76, 76); font-style: italic;\"><br \/><\/span><\/p>\n<p style=\"MARGIN-LEFT: 12em\"><span style=\"color: rgb(76, 76, 76); \">HTTP(HyperText\n Transfer Protocol)\ub780? : \ucd08\ubcf8\ubb38\uc804\uc1a1\uaddc\uc57d,\ud558\uc774\ud37c\ubcf8\ubb38\uc804\uc1a1\uaddc\uc57d\uc73c\ub85c WWW(World Wide Web)\uc0c1\uc5d0\uc11c \uc815\ubcf4\ub97c \n\uc8fc\uace0 \ubc1b\uc744 \uc218 \uc788\ub294 \ud504\ub85c\ud1a0\ucf5c\uc774\ub2e4. \uc8fc\ub85c HTML(HyperText Markup Language) \ubb38\uc11c\ub97c \uc8fc\uace0 \ubc1b\ub294 \ub370\uc5d0 \uc4f0\uc778\ub2e4.<\/span><\/p>\n<p style=\"MARGIN-LEFT: 8em\"><br \/><\/p>\n<p style=\"MARGIN-LEFT: 12em\">&nbsp;<\/p>\n<p style=\"MARGIN-LEFT: 8em\">&nbsp;<\/p>\n<p style=\"MARGIN-LEFT: 4em\"><span style=\"COLOR: rgb(153,0,133)\"><span style=\"FONT-SIZE: 10pt\">1-2. Proc* \ud655\uc7a5 \ubc94\uc704<\/span><\/span><\/p><p style=\"MARGIN-LEFT: 4em\"><span style=\"COLOR: rgb(153,0,133)\"><span style=\"FONT-SIZE: 10pt\"><br \/><\/span><\/span><\/p>\n<p style=\"MARGIN-LEFT: 8em\"><span style=\"font-size:10pt;\"><span style=\"COLOR: rgb(0,0,0)\">Pro*C\ub294 \uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uc5f0\ub3d9\ud560 \uc218 \uc788\ub294 C \ud504\ub85c\uadf8\ub7a8\uc774\ub2e4. C\ud504\ub85c\uadf8\ub7a8\uc774\uae30 \ub54c\ubb38\uc5d0 C\ud504\ub85c\uadf8\ub7a8\uc73c\ub85c \ucc98\ub9ac\ud560 \uc218 \uc788\ub294 \ub2e4\uc591\ud55c \uae30\ub2a5\uc744 Pro*C\ub85c\ub3c4 \ucc98\ub9ac\ud560 \uc218 \uc788\ub2e4. Pro*C\uc758 \ud655\uc7a5\ubc94\uc704\ub97c \uc694\uc57d\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/span><\/span><\/p><p style=\"MARGIN-LEFT: 8em\"><span style=\"font-size:10pt;\"><span style=\"COLOR: rgb(0,0,0)\"><br \/><\/span><\/span><\/p>\n<p style=\"MARGIN-LEFT: 12em\"><span style=\"font-size:9pt;\">1. \uc57c\uac04 \ud639\uc740 \uc8fc\uac04 \ubc30\uce58 \ud504\ub85c\uadf8\ub7a8<\/span><\/p>\n<p style=\"MARGIN-LEFT: 12em\"><span style=\"COLOR: rgb(0,0,0); FONT-SIZE: 10pt\">2. \ubbf8\ub4e4\uc6e8\uc5b4 \ud504\ub85c\uadf8\ub7a8(Tuxedo, Tmax, Entera)<\/span><\/p>\n<p style=\"MARGIN-LEFT: 12em\"><span style=\"COLOR: rgb(0,0,0); FONT-SIZE: 10pt\">3. OLTP \ud504\ub85c\uadf8\ub7a8<\/span><\/p>\n<p style=\"MARGIN-LEFT: 12em\"><span style=\"COLOR: rgb(0,0,0); FONT-SIZE: 10pt\">&nbsp; &nbsp; - TCP\/IP \ubaa8\ub4c8\uacfc \uacb0\ud569\ud55c \uc790\ub8cc \uc0dd\uc131 \ubc0f \uc804\uc1a1 \ud504\ub85c\uadf8\ub7a8(EDI)<\/span><\/p>\n<p style=\"MARGIN-LEFT: 12em\"><span style=\"COLOR: rgb(0,0,0); FONT-SIZE: 10pt\">&nbsp; &nbsp; - \uc628\ub77c\uc778 \ud504\ub85c\uadf8\ub7a8\uc73c\ub85c \uc774\ub8e8\uc5b4\uc9c4 \ub2e4\ub7c9\uc758 \uc790\ub8cc \uac00\uacf5 \ud504\ub85c\uadf8\ub7a8\uc744 Pro*C\ub85c \uc774\uad00\ud558\uc5ec \uc131\ub2a5 \uac1c\uc120<\/span><\/p>\n<p style=\"MARGIN-LEFT: 12em\"><span style=\"COLOR: rgb(0,0,0); FONT-SIZE: 10pt\"><br \/><\/span><\/p>\n<p style=\"MARGIN-LEFT: 12em\"><span style=\"color: rgb(76, 76, 76); font-size: 10pt; \">Tuxedo\n \ub780? : Oracle Tuxedo\ub294 \uc9c0\ub09c 30\ub144 \uac04 \uc218 \ub9ce\uc740 \ubc30\uce58\ub97c \ud1b5\ud574 \uc131\ub2a5\uba74\uc5d0\uc11c \uc2e0\ub8b0\ub97c \uc5bb\uc740 \uc804\uc138\uacc4\uc801\uc73c\ub85c \uac00\uc7a5 \ub9ce\uc774 \uc0ac\uc6a9\ub418\ub294\n \ucef4\ud4e8\ud305 \ud50c\ub7ab\ud3fc \uc911 \ud558\ub098\uc774\ub2e4. \uc774\ud50c\ub7ab\ud3fc\uc740 \ucd5c\uc2e0 SOA(\uc11c\ube44\uc2a4 \uc911\uc2ec \uc544\ud0a4\ud14d\ucc98)\ud45c\uc900 \ubc0f \uae30\uc220\uacfc \uc218\ub144\uc5d0 \uac78\uccd0 \uc785\uc99d\ub41c \uc624\ub77c\ud074\uc758 \uc2e0\ub8b0\uc131, \n\uc131\ub2a5 \ubc0f \uc131\uc219\ub3c4\uac00 \uacb0\ud569\ub418\uc5b4 \ubbf8\uc158 \ud06c\ub9ac\ud2f0\uceec \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc774 \uc0ac\uc6a9\uc790\uc758 \ud658\uacbd\uc5d0 \uac00\uc7a5 \uc801\ud569\ud558\uac8c \uc0ac\uc6a9\ub420\uc218 \uc788\ub3c4\ub85d \uc9c0\uc6d0\ud55c\ub2e4.<\/span><\/p>\n<p style=\"MARGIN-LEFT: 12em\"><span style=\"FONT-STYLE: italic; COLOR: rgb(76,76,76); FONT-SIZE: 10pt\"><br \/><\/span><\/p>\n<p style=\"MARGIN-LEFT: 12em\"><span style=\"color: rgb(76, 76, 76); font-size: 10pt; \">Tmax(Transaction\n MAXimization) \ub780? : \ubd84\uc0b0\ub41c \ud658\uacbd\uc5d0\uc11c \ub2e4\ub978 \uae30\uc885 \ucef4\ud4e8\ud130 \uac04\uc758 \ud2b8\ub799\uc7ad\uc158 \ucc98\ub9ac\uc640 \ubd80\ud558\ubd84\uc0b0 \ub3d9\uc791\uc744 \ucc98\ub9ac\ud558\uace0 \uc624\ub958\uac00 \ubc1c\uc0dd\ud560\n \ub54c \uadf8\uc5d0 \uc54c\ub9de\uc740 \uc870\uce58\ub97c \ub2f4\ub2f9\ud558\ub294 \ud2f0\ub9e5\uc2a4\uc18c\ud504\ud2b8\uc758 TP\ubaa8\ub2c8\ud130(TP-Monitor)\uc81c\ud488\uc774\ub2e4.<\/span><\/p>\n<p style=\"MARGIN-LEFT: 12em\"><span style=\"FONT-STYLE: italic\"><br \/><\/span><\/p>\n<p style=\"MARGIN-LEFT: 12em\">OLTP(On-Line Transaction Processing) \ub780? : \uc628\ub77c\uc778 \uc5c5\ubb34\uc758 \ucc98\ub9ac \ud615\ud0dc\uc758 \ud558\ub098\uc774\ub2e4. \ud130\ubbf8\ub110\uc5d0\uc11c \ubc1b\uc740 \uba54\uc2dc\uc9c0\ub97c \ub530\ub77c \ud638\uc2a4\ud2b8\uac00 \ucc98\ub9ac\ub97c \ud558\uace0, \uadf8 \uacb0\uacfc\ub97c \ub2e4\uc2dc \ud130\ubbf8\ub110\uc5d0 \ub418\ub3cc\ub824\uc8fc\ub294 \ubc29\ubc95\uc744 \ub9d0\ud55c\ub2e4.<\/p>\n<p style=\"MARGIN-LEFT: 12em\"><br \/><\/p>\n<p style=\"MARGIN-LEFT: 4em\"><span style=\"COLOR: rgb(153,0,133)\"><span style=\"FONT-SIZE: 10pt\">1-3. \ud504\ub85c\uadf8\ub7a8 \uc791\uc131 \ubc29\uc2dd<\/span><\/span><\/p><p style=\"MARGIN-LEFT: 4em\"><span style=\"COLOR: rgb(153,0,133)\"><span style=\"FONT-SIZE: 10pt\"><br \/><\/span><\/span><\/p>\n<p style=\"MARGIN-LEFT: 8em\"><span style=\"font-size:9pt;\"><span style=\"COLOR: rgb(0,0,0)\">4GL \ud504\ub85c\uadf8\ub7a8\uc73c\ub85c DB \ud578\ub4e4\ub9c1 \ud504\ub85c\uadf8\ub7a8\uc744 \uc791\uc131\ud558\uae30 \uc704\ud574\uc11c\ub294 DB\uc811\uc18d \ubc29\uc2dd\uc744 \uc120\ud0dd\ud574\uc57c \ud55c\ub2e4.<\/span><\/span><\/p>\n<p style=\"MARGIN-LEFT: 12em\"><span style=\"COLOR: rgb(0,0,0); FONT-SIZE: 10pt\">ex) ODBC \ubc29\uc2dd, OLE-DB \ubc29\uc2dd &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(\ud604\uc7ac \uc5c5\ubb34\uc5d0\uc11c ODBC\ubc29\uc2dd\uc744 \uc0ac\uc6a9\ud558\uace0 \uc788\ub2e4.. \uc660\uc9c0 \uc775\uc219\ud55c \ub290\ub08c\uc774\ub2e4..)<\/span><\/p>\n<p style=\"MARGIN-LEFT: 8em\"><span style=\"COLOR: rgb(0,0,0); FONT-SIZE: 10pt\"><br \/><\/span><\/p>\n<p style=\"MARGIN-LEFT: 8em\"><span style=\"COLOR: rgb(0,0,0); FONT-SIZE: 10pt\">Pro*C\n \ub294 \ucf54\ub529 \uc2dc\uc810\uc5d0\uc11c Header \ud30c\uc77c \uc120\uc815, \ud504\ub85c\uadf8\ub7a8 \ubc29\uc2dd\uc758 \uc120\uc815, \ucef4\ud30c\uc77c \uc635\uc158\uc758 \ubcc0\uacbd\uc744 \ud1b5\ud574 \uc791\uc131 \ubc29\uc2dd\uc744 \uc120\ud0dd\ud558\uc5ec \uc0ac\uc6a9\ud560 \uc218 \n\uc788\ub2e4. Pro*C \uc5d0\uc11c \ud504\ub85c\uadf8\ub7a8 \uc791\uc131 \ubc29\uc2dd\uc740 \ub450 \uac00\uc9c0\ub85c \ub098\ub258\uba70, \ud558\ub098\ub294 \ub0b4\uc7a5 SQL \ubc29\uc2dd\uc774\uace0, \ub2e4\ub978 \ud558\ub098\ub294 OCI(Oracle \nCall Interface) \ubc29\uc2dd\uc774\ub2e4.<\/span><\/p>\n<p style=\"MARGIN-LEFT: 8em\"><span style=\"COLOR: rgb(0,0,0); FONT-SIZE: 10pt\"><br \/><\/span><\/p>\n<p style=\"MARGIN-LEFT: 12em\"><span style=\"font-size:9pt;\">ODBC(Open DataBase connectivity) \ub780? : \uc5b4\ub5a4 \uc751\uc6a9\ud504\ub85c\uadf8\ub7a8\uc744 \uc0ac\uc6a9\ud558\ub294\uc9c0\uc5d0 \uad00\uacc4\uc5c6\uc774, \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc790\uc720\ub86d\uac8c \uc0ac\uc6a9\ud558\uae30 \uc704\ud558\uc5ec \ub9cc\ub4e0 \uc751\uc6a9\ud504\ub85c\uadf8\ub7a8\uc758 \ud45c\uc900\ubc29\ubc95\uc744 \ub9d0\ud55c\ub2e4.<\/span><\/p>\n<p style=\"MARGIN-LEFT: 12em\"><span style=\"FONT-STYLE: italic; COLOR: rgb(76,76,76); FONT-SIZE: 10pt\"><br \/><\/span><\/p>\n<p style=\"MARGIN-LEFT: 12em\"><span style=\"FONT-SIZE: 10pt\"><span style=\"color: rgb(76, 76, 76); font-size: 9pt; \">OLE-DB(Object\n Linking and Embedding, Database) \ub780? : \ub9c8\uc774\ud06c\ub85c\uc18c\ud504\ud2b8\uc0ac\uac00 \uac1c\ubc1c\ud55c API\ub85c, \ud1b5\uc77c\ub41c \ubc29\uc2dd\uc73c\ub85c \uc800\uc7a5\ub41c \n\uc5ec\ub7ec \uc885\ub958\uc758 \ub370\uc774\ud130\uc5d0 \uc811\uadfc\ud558\uae30 \uc704\ud574\uc11c \ub9cc\ub4e4\uc5b4\uc84c\ub2e4. \ucef4\ud3ec\ub10c\ud2b8 \uc624\ube0c\uc81d\ud2b8 \ubaa8\ub378(COM)\uc744 \uc0ac\uc6a9\ud558\uc5ec \ucd94\uac00\ub41c \uc778\ud130\ud398\uc774\uc2a4 \uc9d1\ud569\uc774\uba70 \uac1d\uccb4 \uc5f0\uacb0\n \uc0bd\uc785\uacfc\ub294 \uad00\ub828\uc774 \uc5c6\ub2e4. ODBC\ub97c \ub192\uc740 \uc218\uc900\uc73c\ub85c \ub300\uccb4\ud558\uba74\uc11c\ub3c4 \uadf8 \ub4a4\ub97c \uc787\ub3c4\ub85d \uc124\uacc4\ub418\uc5c8\ub2e4.<\/span><span style=\"COLOR: rgb(0,0,0)\"> <\/span><br \/><\/span><\/p>\n<p style=\"MARGIN-LEFT: 8em\"><span style=\"COLOR: rgb(0,0,0); FONT-SIZE: 10pt\"><br \/><\/span><\/p>\n<p style=\"MARGIN-LEFT: 4em\"><span style=\"FONT-SIZE: 10pt\"><span style=\"COLOR: rgb(153,0,133)\">&nbsp; &nbsp; &nbsp; <\/span><span style=\"FONT-SIZE: 9pt\"><span style=\"COLOR: rgb(153,0,133)\">&nbsp;<\/span><span style=\"COLOR: rgb(217,65,197)\">(1) \ub0b4\uc7a5 SQL \ubc29\uc2dd<\/span><\/span><\/span><\/p><p style=\"MARGIN-LEFT: 4em\"><span style=\"font-size:9pt;\"><span style=\"COLOR: rgb(217,65,197)\"><br \/><\/span><\/span><\/p>\n<p style=\"MARGIN-LEFT: 8em\"><span style=\"font-size:9pt;\"><span style=\"COLOR: rgb(0,0,0)\">\ub0b4\uc7a5 SQL \ubc29\uc2dd\uc774\ub780 C \ud504\ub85c\uadf8\ub7a8 \ub0b4\ubd80\uc5d0\uc11c 'EXEC SQL' \uc774\ub77c\ub294 \uc811\ub450\uc0ac \ub4a4\uc5d0 SQL \ubb38\uc7a5\uc744 \uc9c1\uc811 \uae30\uc220\ud558\ub294 \ubc29\uc2dd\uc774\ub2e4.<\/span><\/span><\/p>\n<p style=\"MARGIN-LEFT: 8em\"><span style=\"COLOR: rgb(0,0,0)\">\ub0b4\uc7a5 SQL \ubb38\uc7a5\uc5d0\ub294 \n\uc77c\ubc18 SQL \ubb38\uc7a5\ubfd0\ub9cc \uc544\ub2c8\ub77c \uc624\ub77c\ud074\uc744 \uc774\uc6a9\ud55c \ub2e4\uc591\ud55c \ud615\uc2dd\uc758 \ub0b4\ubd80 \ubb38\uc7a5\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc73c\uba70, \ubbf8\ub9ac \uc0dd\uc131\ub418\uc5b4 \uc788\ub294 Stored \nProcedure, Package \ub610\ub294 \uac1c\ubc1c\uc790\uac00 \uc784\uc758\ub85c \uc791\uc131\ud55c PL\/SQL\ub3c4 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4. \uc989, \uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \n\uc0ac\uc6a9\ud558\ub294 \ubaa8\ub4e0\ubb38\uc7a5 DML, DDL, DCL, PL\/SQL, \uc77c\ubc18 SQL \ubb38\uc7a5\uc744 \ub0b4\uc7a5 SQL \ubb38\uc7a5\uc5d0 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4.<\/span><\/p>\n<p style=\"MARGIN-LEFT: 8em\"><span style=\"font-size:9pt;\"><span style=\"COLOR: rgb(0,0,0); TEXT-DECORATION: underline line-through\"><br \/><\/span><\/span><\/p>\n<p style=\"margin-left: 8em; text-align: center; \"><span style=\"font-weight: bold; color: rgb(217, 65, 197);\">\u203b \ub0b4\uc7a5 SQL \ubb38\uc7a5 \uad6c\ubb38 \ubc29\uc2dd\uc758 \ud504\ub85c\uadf8\ub7a8 \uad6c\ubb38<\/span><\/p><p style=\"margin-left: 8em; text-align: center; \"><br \/><\/p><p style=\"margin-left: 8em; text-align: center; clear: none; float: none;\"><img decoding=\"async\" editor_component=\"image_link\" src=\"\/blog\/wp-content\/uploads\/cms_xe\/img0739.png\" alt=\"\" \/><\/p><p style=\"margin-left: 8em; text-align: center; \"><br \/><\/p><p style=\"MARGIN-LEFT: 8em\"><span style=\"color: rgb(0, 0, 0);\"><br \/><\/span><\/p>\n<p style=\"MARGIN-LEFT: 8em\"><br \/><\/p>\n<p style=\"MARGIN-LEFT: 4em\"><span style=\"FONT-SIZE: 10pt\"><span style=\"COLOR: rgb(217,65,197); FONT-SIZE: 9pt\">&nbsp; &nbsp; &nbsp; &nbsp;(2) OCI \ubc29\uc2dd<\/span><\/span><\/p><p style=\"MARGIN-LEFT: 4em\"><span style=\"FONT-SIZE: 10pt\"><span style=\"COLOR: rgb(217,65,197); FONT-SIZE: 9pt\"><br \/><\/span><\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"FONT-SIZE: 10pt\"><span style=\"font-size: 9pt; color: rgb(0, 0, 0);\">OCI(Oracle Call Interface) \ubc29\uc2dd\uc774\ub780 OCI \ub77c\uc774\ube0c\ub7ec\ub9ac\ub97c \ud1b5\ud574\uc11c \uc624\ub77c\ud074 SQL \ubb38\uc7a5\uc744 \uc9c1\uc811 \ud638\ucd9c\ud558\uc5ec \uc0ac\uc6a9\ud558\ub294 \ubc29\uc2dd\uc774\ub2e4.<\/span><\/span><\/p><p style=\"margin-left: 12em; \"><span style=\"FONT-SIZE: 10pt\"><span style=\"font-size: 9pt; color: rgb(0, 0, 0);\"><br \/><\/span><\/span><\/p><p style=\"margin-left: 12em; \"><span style=\"FONT-SIZE: 10pt\"><span style=\"font-size: 9pt; color: rgb(0, 0, 0);\">\uc7a5\n\uc810: \ub0b4\uc7a5 SQL \ubc29\uc2dd\uc5d0 \ube44\ud574\uc11c \uc870\uae08 \ub354 \ud558\uc704 \ub808\ubca8\uc5d0 \ud574\ub2f9\ud558\ub294 \ud504\ub85c\uadf8\ub798\ubc0d \ubc29\uc2dd\uc73c\ub85c\uc11c OCI\ub97c \ud1b5\ud574\uc11c DB\ud578\ub4e4\ub9c1 \uc791\uc5c5\uc744 \uc2e4\ud589\ud558\uae30 \n\ub54c\ubb38\uc5d0 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\uc758 \uc790\uc6d0\uc744 \ud6a8\uc728\uc801\uc73c\ub85c \uad00\ub9ac\ud558\uace0 SQL \ubb38\uc7a5 \uc218\ud589\uc758 \uac01 \ub2e8\uacc4\ub97c \uc9c1\uc811 \uc81c\uc5b4\ud560 \uc218 \uc788\ub2e4<br \/><\/span><\/span><\/p><p style=\"margin-left: 12em; \"><span style=\"FONT-SIZE: 10pt\"><span style=\"font-size: 9pt; color: rgb(0, 0, 0);\"><br \/><\/span><\/span><\/p><p style=\"margin-left: 12em; \"><span style=\"FONT-SIZE: 10pt\"><span style=\"font-size: 9pt; color: rgb(0, 0, 0);\">\ub2e8\uc810: \ud504\ub85c\uadf8\ub798\ubc0d \ubc29\ubc95\uc5d0 \uc788\uc5b4 \ub0b4\uc7a5 SQL \ud504\ub85c\uadf8\ub7a8\uc5d0 \ube44\ud574 \ubcf5\uc7a1\ud558\uae30 \ub54c\ubb38\uc5d0 \uac1c\ubc1c\uc790\uc758 \uc219\ub828\ub3c4\uac00 \uc694\uad6c\ub41c\ub2e4\ub294 \ub2e8\uc810\uc774 \uc788\ub2e4.<\/span><\/span><\/p><p style=\"margin-left: 12em; \"><span style=\"FONT-SIZE: 10pt\"><span style=\"font-size: 9pt; color: rgb(0, 0, 0);\"><br \/><\/span><\/span><\/p><p style=\"margin-left: 12em; \"><span style=\"color: rgb(0, 0, 0);\">\uc774 \ucc45\uc740 \ub0b4\uc7a5 SQL \ubb38\uc7a5 \ubc29\uc2dd\uc744 \uc0ac\uc6a9\ud558\uace0, OCI \ubc29\uc2dd \ud504\ub85c\uadf8\ub7a8\uc5d0 \ub300\ud574\uc11c\ub294 \ub2e4\ub8e8\uc9c0 \uc54a\ub294\ub2e4.<\/span><\/p><p style=\"margin-left: 12em; \"><span style=\"color: rgb(0, 0, 0);\"><br \/><\/span><\/p><p style=\"margin-left: 12em; text-align: center; \"><span style=\"color: rgb(217, 65, 197); font-weight: bold; text-align: center; \">\u203b \ub0b4\uc7a5 SQL \ubc29\uc2dd\uacfc OCI \ubc29\uc2dd \ube44\uad50<\/span><\/p><p style=\"margin-left: 8em; text-align: center; \"><br \/><\/p><p style=\"margin-left: 8em; text-align: center; clear: none; float: none;\"><img decoding=\"async\" editor_component=\"image_link\" src=\"\/blog\/wp-content\/uploads\/cms_xe\/img0375.jpg\" alt=\"\" \/><\/p><p style=\"margin-left: 8em; text-align: center; \"><br \/><\/p><p style=\"margin-left: 12em; \"><span style=\"color: rgb(0, 0, 0);\"><br \/><\/span><\/p><p style=\"margin-left: 8em; \"><br \/><\/p>\n<p style=\"MARGIN-LEFT: 4em\"><span style=\"COLOR: rgb(153,0,133)\"><span style=\"FONT-SIZE: 10pt\">1-4. Pro*C\uc758 \ub370\uc774\ud130 \ud615<\/span><\/span><\/p><p style=\"MARGIN-LEFT: 4em\"><span style=\"COLOR: rgb(153,0,133)\"><span style=\"FONT-SIZE: 10pt\"><br \/><\/span><\/span><\/p>\n<p style=\"margin-left: 8em; \">Pro*C\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 \ub370\uc774\ud130 \ud615\uc740 C \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 \uc77c\ubc18\uc801\uc778 \ub370\uc774\ud130 \ud615\uacfc Pro*C\uc5d0\uc11c\ub9cc \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uace0\uc720\ud55c \ud615\ud0dc\uc758 \ub370\uc774\ud130 \ud615\uc73c\ub85c \uad6c\uc131\ub418\uc5b4 \uc788\ub2e4.<\/p><p style=\"margin-left: 8em; \"><br \/><\/p><p style=\"margin-left: 8em; \">Pro*C \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 \ub370\uc774\ud130\ud615<\/p><ul style=\"list-style-type: square; \"><ul style=\"list-style-type: square; \"><ul style=\"list-style-type: square; \"><ul style=\"list-style-type: square; \"><ul style=\"list-style-type: square; \"><ul style=\"list-style-type: square; \"><li>\uae30\ubcf8\uc801\uc778 \ub370\uc774\ud130 \ud615\uc758 \uc77c\ucc28\uc6d0 \ubc30\uc5f4<\/li><li>CHAR \ub370\uc774\ud130 \ud615\uacfc VARCHAR \ub370\uc774\ud130 \ud615\uc758 \uc774\ucc28\uc6d0 \ubc30\uc5f4<\/li><li>\uae30\ubcf8\uc801\uc778 \ub370\uc774\ud130 \ud615\uc5d0 \ub300\ud55c \ud3ec\uc778\ud130<\/li><li>\uc0ac\uc6a9\uc790 \uc815\uc758\uc758 typedef<\/li><li>\uad6c\uc870\uccb4<\/li><li>\ubc30\uc5f4\uc758 \uad6c\uc870\uccb4<\/li><li>\uad6c\uc870\uccb4\uc5d0 \ub300\ud55c \ud3ec\uc778\ud130<\/li><li>\uad6c\uc870\uccb4 \ubc30\uc5f4&nbsp;<\/li><\/ul><\/ul><\/ul><\/ul><\/ul><\/ul>\n<p style=\"margin-left: 8em; \"><span style=\"font-style: italic; font-weight: bold; color: rgb(0, 0, 0);\"><br \/><\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0); \">Pro*C \uc5ed\uc2dc C \ud504\ub85c\uadf8\ub7a8\uc774\uae30 \ub54c\ubb38\uc5d0 C\uc758 \uc77c\ubc18\uc801\uc778 \ub370\uc774\ud130 \ud615\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4. \uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ub370\uc774\ud130 \ud615\uacfc C \ud504\ub85c\uadf8\ub7a8\uc758 \ub370\uc774\ud130 \ud615\uc740 \ud638\ud658 \ub41c\ub2e4.<\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"font-style: italic; font-weight: bold; color: rgb(0, 0, 0);\"><br \/><\/span><\/p><p style=\"margin-left: 8em; text-align: center; \"><span style=\"color: rgb(217, 65, 197); font-weight: bold; text-align: center; \">\u203b \uc624\ub77c\ud074 \ub370\uc774\ud130 \ud615\uacfc C \ub370\uc774\ud130 \ud615\uc758 \ud638\ud658\uc131<\/span><\/p><p style=\"margin-left: 8em; text-align: center; \"><br \/><\/p><p style=\"margin-left: 8em; text-align: center; clear: none; float: none;\"><img decoding=\"async\" editor_component=\"image_link\" src=\"\/blog\/wp-content\/uploads\/cms_xe\/img0159.png\" alt=\"\" \/><\/p><p style=\"margin-left: 8em; text-align: center; \"><br \/><\/p><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0); \"><span style=\"font-weight: bold; font-style: italic;\"><br \/><\/span><\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0); \">\uc624\ub77c\ud074\uc758 \ub370\uc774\ud130\ud615\uacfc C\uc758 \ub370\uc774\ud130 \ud615\uc740 \uc704 \ud45c\uc640 \uac19\uc774 \uce58\ud658\ud558\uc5ec \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4. \uadf8\ub7ec\ubbc0\ub85c \uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uc5f0\uacb0\ud574\uc11c \ud504\ub85c\uadf8\ub798\ubc0d\uc744 \ud568\uc5d0 \uc788\uc5b4 \ud070 \uc81c\uc57d\uc774 \uc5c6\ub2e4.<br \/><\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0); \"><br \/><\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0);\">\ub2e4\ub9cc VARCHAR \ud615\uc758 \uacbd\uc6b0 \ub370\uc774\ud130 \ud615\uc758 \ud2b9\uc131\uc0c1 VARCHAR uid[20]\uc73c\ub85c \uc120\uc5b8\ud558\uba74 \uc2e4\uc81c\ub85c\ub294 \uad6c\uc870\uccb4 \ud615\uc2dd\uc73c\ub85c \ub2e4\uc74c\uacfc \uac19\uc774 \uc0dd\uc131\ub41c\ub2e4.<\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0);\"><br \/><\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0); font-weight: bold;\">struct{<\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0); font-weight: bold;\">&nbsp; &nbsp; &nbsp;unsigned short int len;<\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0); font-weight: bold;\">&nbsp; &nbsp; &nbsp;unsigned char arr[20];<\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0); font-weight: bold;\">}uid;<\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0); \"><br \/><\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0); \">\uc0ac\uc6a9\ubc95 \ub610\ud55c \uad6c\uc870\uccb4\uc774\uae30 \ub54c\ubb38\uc5d0 C\uc758 char \ud0c0\uc785\uacfc \ub2e4\ub974\uac8c \uad6c\uc870\uccb4\uc758 \uc0ac\uc6a9\ubc95\uc744 \ub530\ub978\ub2e4.<\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0); \"><br \/><\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0); font-weight: bold;\">VARCHAR uid[20];<\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0); font-weight: bold;\">strcpy((char*)uid.arr, \"userid\");<\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0); font-weight: bold;\">uid.len = (short)strlen((char*)uid.arr);<\/span><\/p>\n<p><span style=\"font-style: italic; font-weight: bold; color: rgb(0, 0, 0);\"><br \/><\/span><\/p>\n<p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0); \">char \n\ud615\uc740 Fixed Data Type \uc73c\ub85c \ub370\uc774\ud130 \ud615\uc758 \uae38\uc774\ub9cc\ud07c \uc800\uc7a5 \uacf5\uac04\uc744 \ucc28\uc9c0\ud558\uace0, VARCHAR \ud615\uc740 \ub370\uc774\ud130\uc758 \uae38\uc774\uc640 \uc0c1\uad00\uc5c6\uc774 \n\ud560\ub2f9\ubc1b\uc740 \ub370\uc774\ud130 \uae38\uc774\ub9cc\ud07c\uc758 \uc800\uc7a5 \uacf5\uac04\uc744 \uac16\ub294\ub2e4. \ub610\ud55c, VARCHAR\ud615\uc740 \uad6c\uc870\uccb4 \ubc0f \ud3ec\uc778\ud130\ub85c\uc758 \ud615\ubcc0\ud658\uc774 \ud544\uc694\ud558\ubbc0\ub85c \uc0ac\uc6a9\uc758 \ud3b8\uc774\uc131\uc740\n \ub5a8\uc5b4\uc9c4\ub2e4.<\/span><span style=\"font-style: italic; font-weight: bold; color: rgb(0, 0, 0);\"><br \/><\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"font-style: italic; font-weight: bold; color: rgb(0, 0, 0);\"><br \/><\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0);\">Pro*C \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c \uc800\uc7a5 \uacf5\uac04\uacfc \ucc98\ub9ac \ubc29\ubc95\uc5d0 \uc788\uc5b4\uc11c \ucc28\uc774\ub97c \ubcf4\uc774\ub294 \ub370\uc774\ud130 \ud615\uc740 char\ud615\uacfc VARHCAR \ud615 \ubc16\uc5d0 \uc5c6\ub2e4.<\/span><\/p>\n<p><br \/><\/p>\n<p><span style=\"COLOR: rgb(153,0,133); FONT-WEIGHT: bold\"><span style=\"FONT-SIZE: 11pt\">2\uc7a5. Pro*C \uc624\ub958 \uc9c4\ub2e8\uacfc \ucc98\ub9ac<\/span><\/span><\/p><p style=\"margin-left: 4em; \"><br \/><\/p><p style=\"margin-left: 4em; \">\ud504\n\ub85c\uadf8\ub7a8\uc744 \uc791\uc131\ud560 \ub54c \uac00\uc7a5 \uc911\uc694\ud55c \uac83\uc740 \uc624\ub958\uc5d0 \ub300\ud55c \uc815\ud655\ud55c \ud578\ub4e4\ub9c1\uacfc \uadf8\uc5d0 \ub300\ud55c \ucc98\ub9ac\uc774\ub2e4. \ud504\ub85c\uadf8\ub7a8 \uc624\uc791\ub3d9 \uc2dc \uc6d0\uc778\uc774 \ubb34\uc5c7\uc778\uc9c0\uc640 \n\uc624\uc791\ub3d9\uc758 \uc6d0\uc778\uc744 \ud574\uacb0\ud558\uae30 \uc704\ud574 \ubb34\uc5c7\uc774 \ud544\uc694\ud55c\uc9c0\ub97c \uc815\ud655\ud788 \uc9da\uc5b4\ub0bc \uc218 \uc788\uc5b4\uc57c \ud55c\ub2e4. \uc5d0\ub7ec\ub098 \uacbd\uace0\ub97c \uac10\uc9c0\ud558\uace0 \uc5d0\ub7ec\uc5d0 \ub300\ud574 \ub354 \ub9ce\uc740 \n\uc815\ubcf4\ub97c \uc5bb\uae30 \uc704\ud574\uc11c\ub294 \ubcc4\ub3c4 \ud1b5\uc2e0 \uc601\uc5ed\uc758 \uc815\ubcf4\ub97c \uac00\uc9c4 \ub3c4\uad6c\uac00 \ud544\uc694\ud558\uba70 Pro*C\uc5d0\uc11c\ub294 SQL \ud1b5\uc2e0 \uc601\uc5ed(SQLCA)\uacfc \uc624\ub77c\ud074 \ud1b5\uc2e0 \n\uc601\uc5ed(ORACA)\uc774\ub77c\ub294 \ub450 \uac1c\uc758 \ud2b9\uc218\ud55c \ub370\uc774\ud130 \uad6c\uc870\ub97c \uc9c0\uc6d0\ud55c\ub2e4.<\/p><p style=\"margin-left: 4em; \"><br \/><\/p>\n<p style=\"MARGIN-LEFT: 4em\"><span style=\"COLOR: rgb(153,0,133)\"><span style=\"FONT-SIZE: 10pt\">2-1. SQLCA&nbsp;<\/span><\/span><span style=\"color: rgb(153, 0, 133); font-size: 13px; line-height: 21px; \">(SQL Communication Area : SQL \ud1b5\uc2e0 \uc601\uc5ed)<\/span><\/p><p style=\"MARGIN-LEFT: 4em\"><span style=\"color: rgb(153, 0, 133); font-size: 13px; line-height: 21px; \"><br \/><\/span><\/p>\n<p style=\"margin-left: 8em; \"><span style=\"font-size: 10pt; \"><span style=\"color: rgb(0, 0, 0);\">\ubaa8\ub4e0 Pro*C \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c \ud504\ub85c\uadf8\ub7a8 \uc2e4\ud589\uc5d0 \uad00\ud55c \uc815\ubcf4\ub97c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uad50\ud658\ud558\uae30 \uc704\ud574\uc11c SQLCA\ub97c \ud544\uc218\ub85c \uc0ac\uc6a9\ud55c\ub2e4. C \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c \ud5e4\ub354 \ud30c\uc77c\uc744 \uc0ac\uc6a9\ud560 \ub54c\uc640 \uac19\uc774 \ud504\ub85c\uadf8\ub7a8\uc758 \uc2dc\uc791 \ubd80\ubd84\uc5d0 \ud5e4\ub354 \ud30c\uc77c\uc744 \ucca8\ubd80\ud574\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4.<\/span><\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0); font-size: 13px; line-height: 21px;\">SQLCA\n\ub294 \uc608\uc678\uc640 \uacbd\uace0\ub97c \uac10\uc9c0\ud55c\ub2e4. SQL \ubb38 \uc18d\uc5d0 \ubcc0\uc218\uc758 \uc218\uac00 \ub108\ubb34 \uc801\uc5b4\uc11c \uc694\uad6c\ub41c \ub370\uc774\ud130\ub97c \ubc18\ud658\ud560 \uc218 \uc5c6\ub294 \uacbd\uc6b0\ub098, \ub370\uc774\ud130 \ucd94\ucd9c \uc2dc \n\ucd94\ucd9c\ud558\ub824\ub294 \ub370\uc774\ud130\uac00 \uc5c6\ub294 \uacbd\uc6b0(ORA-1403) \ub4f1 \ub2e4\uc591\ud55c \uacbd\uc6b0\uc758 \uc5d0\ub7ec\uc640 \uacbd\uace0\uc5d0 \ub300\ud574 SQLCA\ub294 SQL \ubb38\uc7a5\uc758 \uc2e4\ud589 \uc2dc\uc810\uc5d0\uc11c \n\uc774\ub97c \uac10\uc9c0\ud558\uace0 \ucd9c\ub825\ud55c\ub2e4.<\/span><\/p><p style=\"margin-left: 12em; \"><span style=\"color: rgb(0, 0, 0); font-size: 13px; line-height: 21px;\"><br \/><\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0); font-size: 13px; line-height: 21px;\">\uc0ac\uc6a9\ubc95 : &nbsp;#include &lt;sqlca.h&gt; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;- C \ud504\ub85c\uadf8\ub7a8 \ubc29\uc2dd<\/span><\/p><p style=\"margin-left: 12em; \"><span style=\"color: rgb(0, 0, 0); font-size: 13px; line-height: 21px;\">&nbsp; EXEC SQL INCLUDE SQLCA; &nbsp; &nbsp;- Pro*C \ubb38\ubc95<br \/><\/span><\/p><p style=\"MARGIN-LEFT: 4em\"><span style=\"COLOR: rgb(153,0,133)\"><span style=\"FONT-SIZE: 10pt\"><br \/><\/span><\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"font-size: 10pt; color: rgb(0, 0, 0);\">SQLCA\ub294 \uc9c1\uc804\uc758 SQL \ubb38\uc7a5\uc758 \ucc98\ub9ac \uacb0\uacfc\uc5d0 \ub300\ud574 SQLCA \ud30c\uc77c\uc5d0 \uc815\uc758\ub418\uc5b4 \uc788\ub294 sqlca \uad6c\uc870\uccb4\uc5d0 \uc815\ubcf4\ub97c \uc800\uc7a5\ud55c\ub2e4.<\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"font-size: 10pt; color: rgb(0, 0, 0);\">\uadf8\ub7ec\ubbc0\ub85c \uac1c\ubc1c\uc790\ub294 \uac01 SQL \ubb38\uc7a5\ub9c8\ub2e4 SQLCA\uc758 \uad6c\uc870\uccb4 \ub0b4\uc6a9\uc744 \uac80\uc0c9\ud558\uc5ec \uc5d0\ub7ec\uc640 \uacbd\uace0 \uc5ec\ubd80\uc5d0 \ub300\ud55c \uc815\ubcf4\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.<\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0); font-size: 13px; line-height: 21px;\"><br \/><\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0); font-size: 13px; line-height: 21px;\">SQLCA\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc815\ubcf4\ub97c \uac00\uc9c0\uace0 \uc788\ub2e4.<\/span><\/p><ul style=\"list-style-type: square; \"><ul style=\"list-style-type: square; \"><ul style=\"list-style-type: square; \"><ul style=\"list-style-type: square; \"><ul style=\"list-style-type: square; \"><ul style=\"list-style-type: square; \"><li><span style=\"color: rgb(0, 0, 0); font-size: 13px; line-height: 21px;\">\uacbd\uace0 \ud50c\ub798\uadf8\uc640 \ucc98\ub9ac \uc0c1\ud669\uc5d0 \uad00\ud55c \uc815\ubcf4<\/span><\/li><li><span style=\"color: rgb(0, 0, 0); font-size: 13px; line-height: 21px;\">\uc5d0\ub7ec \ucf54\ub4dc<\/span><\/li><li><span style=\"color: rgb(0, 0, 0); font-size: 13px; line-height: 21px;\">\uc9c4\ub2e8 \uc815\ubcf4<\/span><\/li><\/ul><\/ul><\/ul><\/ul><\/ul><\/ul><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0); font-size: 13px; line-height: 21px;\">SQLCA \uad6c\uc870\uccb4\uc758 \uac1c\uad04\uc801\uc778 \uad6c\uc870 \ubc0f \uad6c\uc870\uccb4\uc758 \uac01 \uba64\ubc84 \uc0c1\uc138 \ub0b4\uc6a9\uc740 \ubcf8\ucc45 18 ~ 20 page \ub97c \ucc38\uace0.<\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0); font-size: 13px; line-height: 21px;\">\uc2e4\uc81c \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c SQLCA\ub97c \uc0ac\uc6a9\ud558\ub294 \uc608\uc81c\ub294 20 page \ucc38\uace0.<\/span><\/p><p style=\"margin-left: 8em; \"><br \/><\/p><p style=\"MARGIN-LEFT: 4em\"><span style=\"COLOR: rgb(153,0,133)\"><span style=\"FONT-SIZE: 10pt\">2-2. ORACA<\/span><\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"COLOR: rgb(153,0,133)\"><span style=\"font-size: 10pt; text-decoration: line-through underline;\"><br \/><\/span><\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0); font-size: 13px; line-height: 21px;\">ORACA\n\ub294 SQLCA\uc5d0\uc11c \uc5bb\uc744 \uc218 \uc788\ub294 \uac83 \ubcf4\ub2e4 \uc870\uae08 \ub354 \ub9ce\uc740 \uc815\ubcf4\ub97c \uc5bb\uc744 \uc218 \uc788\ub294 \ub370\uc774\ud130 \uad6c\uc870\uc774\ub2e4. ORACA\ub294 \uc2e4\ud589 \uc2dc \ubc1c\uc0dd\ud558\ub294 \n\uc5d0\ub7ec\ubfd0\ub9cc\uc774 \uc544\ub2c8\ub77c, \uc131\ub2a5 \ud1b5\uacc4\uc5d0 \ub300\ud55c \ubcf4\uc870 \uc815\ubcf4\ub3c4 \uc81c\uacf5\ud55c\ub2e4. ORACA\ub294 \ud544\uc218\uac00 \uc544\ub2cc \uc120\ud0dd\uc774\uba70 SQLCA\uc640 \ub3d9\uc77c\ud558\uac8c Include\n \ubd80\ubd84\uc5d0\uc11c \ucc38\uc870\ud558\uc5ec \uc0ac\uc6a9\ud55c\ub2e4.<\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"text-decoration: underline line-through;\"><br \/><\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0);\">ORACA\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc815\ubcf4\ub97c \uac00\uc9c0\uace0 \uc788\ub2e4.<\/span><\/p><ul style=\"list-style-type: square; \"><ul style=\"list-style-type: square; \"><ul style=\"list-style-type: square; \"><ul style=\"list-style-type: square; \"><ul style=\"list-style-type: square; \"><ul style=\"list-style-type: square; \"><li><span style=\"color: rgb(0, 0, 0);\">\ud604\uc7ac SQL \ubb38\uc758 \ud14d\uc2a4\ud2b8(orastxt)<\/span><\/li><li><span style=\"color: rgb(0, 0, 0);\">\uc5d0\ub7ec\uac00 \uc788\ub294 \ud30c\uc77c\uc758 \uc774\ub984(orasfrm)<\/span><\/li><li><span style=\"color: rgb(0, 0, 0);\">\uc5d0\ub7ec\uac00 \uc788\ub294 \ud589\uc758 \ubc88\ud638(oraslnr)<\/span><\/li><li><span style=\"color: rgb(0, 0, 0);\">SQL \ubb38 \ubcf4\uc874 \ud50c\ub798\uadf8(orastxtf) : \uc774 \ud50c\ub798\uadf8\ub97c \uc124\uc815\ud568\uc73c\ub85c\uc368 \uc5b4\ub290 \uc870\uac74\uc73c\ub85c \ubb38\uc744 \ubcf4\uc874\ud560 \uac83\uc778\uc9c0\ub97c \uc120\ud0dd\ud560 \uc218 \uc788\ub2e4.<\/span><\/li><li><span style=\"color: rgb(0, 0, 0);\">DEBUG \ucc98\ub9ac\uc758 \uc0ac\uc6a9 \ud5c8\uac00 \ud50c\ub798\uadf8: \uc774 \ud50c\ub798\uadf8\ub294 0\uc774\ub098 1\uc744 \uc124\uc815\ud560 \uc218 \uc788\uc73c\uba70, 1\uc744 \uc124\uc815\ud55c \uacbd\uc6b0\uc5d0\ub294 \ubaa8\ub4e0 DEBUG \ucc98\ub9ac\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4.<\/span><\/li><li><span style=\"color: rgb(0, 0, 0);\">\ucee4\uc11c \uce90\uc2dc \uac80\uc0ac(orahchf)<br \/><\/span><\/li><\/ul><\/ul><\/ul><\/ul><\/ul><\/ul><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0);\">ORACA \uad6c\uc870\uccb4\uc758 \uad6c\uc870 \ubc0f \uad6c\uc870\uccb4\uc758 \uac01 \uba64\ubc84 \uc0c1\uc138 \ub0b4\uc6a9\uc740 23 ~ 24 page \ucc38\uace0.<\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0);\">\uc2e4\uc81c \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c ORACA\ub97c \uc0ac\uc6a9\ud558\ub294 \uc608\uc81c\ub294 25~26 page \ucc38\uace0.<\/span><\/p><p style=\"margin-left: 8em; \"><br \/><\/p>\n<p style=\"MARGIN-LEFT: 4em\"><span style=\"COLOR: rgb(153,0,133)\"><span style=\"FONT-SIZE: 10pt\">2-3. \uc624\ub958 \uac80\ucd9c \ubc0f \ucc98\ub9ac<\/span><\/span><\/p><p style=\"margin-left: 4em; \"><span style=\"font-size: 10pt; color: rgb(153, 0, 133); \"><br \/><\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"font-size: 10pt; \"><span style=\"font-size: 9pt; \"><span style=\"color: rgb(0, 0, 0);\">\uc624\ub958 \uac80\ucd9c\uacfc \ucc98\ub9ac \ubc29\ubc95\uc5d0\ub294 \uba85\uc2dc\uc801 \uc624\ub958 \ucc98\ub9ac \ubc29\uc2dd\uacfc \ubb35\uc2dc\uc801 \uc624\ub958 \ucc98\ub9ac \ubc29\uc2dd 2\uac00\uc9c0\uac00 \uc788\ub2e4.<\/span><\/span><\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"font-size: 10pt; \"><span style=\"font-size: 9pt; \"><span style=\"color: rgb(0, 0, 0);\"><br \/><\/span><\/span><\/span><\/p>\n<p style=\"MARGIN-LEFT: 4em\"><span style=\"FONT-SIZE: 10pt\"><span style=\"COLOR: rgb(153,0,133)\">&nbsp; &nbsp; &nbsp; &nbsp;<\/span><\/span><span style=\"color: rgb(217, 65, 197); font-size: 9pt; \">(1) \uba85\uc2dc\uc801 \uc624\ub958 \ucc98\ub9ac<\/span><\/p><p style=\"MARGIN-LEFT: 4em\"><span style=\"color: rgb(217, 65, 197); font-size: 9pt; \"><br \/><\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"FONT-SIZE: 10pt\"><span style=\"font-size: 9pt; color: rgb(0, 0, 0);\">Pro*\n C \ud504\ub85c\uadf8\ub7a8 \uc548\uc758 SQL \ubb38\uc7a5 \ub610\ub294 EXEC SQL \ubb38\uc7a5\uc744 \uc2e4\ud589\ud55c \ud6c4\uc5d0 \ub9e4\ubc88 SQL \ubb38\uc7a5\uc758 \uc624\ub958\ub97c \uac80\uc0ac\ud558\uace0 \uc774\uc5d0 \ub300\ud55c \ucc98\ub9ac\ub97c \n\uae30\uc220\ud558\ub294 \ubc29\uc2dd\uc774\ub2e4. \uc989, \ubc1c\uc0dd\ud558\ub294 \uac00\ub2a5\ud55c \ubaa8\ub4e0 \ubd80\ubd84\uc744 \uba85\uc2dc\uc801\uc73c\ub85c \uae30\uc220\ud558\uc5ec \ucc98\ub9ac\ud558\ub294 \ubc29\ubc95\uc73c\ub85c\uc11c \uac00\uc7a5 \ub9ce\uc774 \uc0ac\uc6a9\ub41c\ub2e4.<\/span><\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"FONT-SIZE: 10pt\"><span style=\"font-size: 9pt; color: rgb(0, 0, 0);\"><br \/><\/span><\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"FONT-SIZE: 10pt\"><span style=\"font-size: 9pt; color: rgb(0, 0, 0);\">\uc7a5\uc810 : \uac1c\ubc1c\uc790\uac00 \uc9c1\uc811 SQL \ubb38\uc7a5 \ubc11\uc5d0 \uae30\uc220\ud558\uac8c \ub418\ubbc0\ub85c \uc6d0\ud558\ub294 \ucc98\ub9ac \ubc29\uc2dd\uc774 \uac00\ub2a5\ud558\ub2e4.<\/span><\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"FONT-SIZE: 10pt\"><span style=\"font-size: 9pt; color: rgb(0, 0, 0);\">\ub2e8\uc810 : \ubbf8\ucc98 \uae30\uc220\ud558\uc9c0 \ubabb\ud55c \ubd80\ubd84\uc5d0 \ub300\ud55c \uc624\ub958 \uac80\ucd9c\uc774 \ubd88\uac00\ub2a5\ud558\uba70, \uac1c\ubc1c\uc790\uc758 \uc2e4\uc218\uc5d0 \ubb34\ubc29\ube44\ub85c \ub178\ucd9c\ub41c\ub2e4.<\/span><\/span><\/p><p style=\"margin-left: 8em; \"><br \/><\/p>\n<p style=\"MARGIN-LEFT: 4em\"><span style=\"COLOR: rgb(217,65,197)\"><span style=\"font-size:9pt;\">&nbsp; &nbsp; &nbsp; &nbsp;(2) \ubb35\uc2dc\uc801 \uc624\ub958 \ucc98\ub9ac<\/span><\/span><\/p><p style=\"MARGIN-LEFT: 4em\"><span style=\"COLOR: rgb(217,65,197)\"><span style=\"font-size:9pt;\"><br \/><\/span><\/span><\/p>\n<p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0);\">\ubaa8\ub4e0 SQL \ubb38\uc7a5\uacfc EXEC SQL \ubb38\uc7a5 \uc2e4\ud589 \ud6c4\uc5d0 \uc624\ub958 \ucc98\ub9ac\ub97c \uae30\uc220\ud558\ub294 \uac83\uc774 \uc544\ub2c8\ub77c, \uc804\uc5ed\uc801 \ud639\uc740 \uc9c0\uc5ed\uc801\uc73c\ub85c \uc624\ub958\uac00 \ubc1c\uc0dd\ud588\uc744 \ub54c\uc758 \ucc98\ub9ac \ubc29\uc548\uc744 \uae30\uc220\ud558\uc5ec \ubaa8\ub4e0 \uc624\ub958\uc5d0 \ub3d9\uc77c\ud55c \ucc98\ub9ac \ubc29\uc2dd\uc744 \uc801\uc6a9\ud55c\ub2e4.<\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0);\"><br \/><\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0);\">\uc7a5\uc810 : \ubaa8\ub4e0 \uc624\ub958 \ub610\ub294 \uacbd\uace0\uc5d0 \ub300\ud574 \ub3d9\uc77c\ud55c \ucc98\ub9ac\uac00 \uac00\ub2a5\ud558\uba70, \uac1c\ubc1c\uc790\uc758 \uc2e4\uc218\uc5d0 \uc758\ud55c \ub204\ub77d\uc774 \ubc1c\uc0dd\ud558\uc9c0 \uc54a\ub294\ub2e4.<\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0);\">\ub2e8\uc810 : \ubcf8 \ucc45\uc5d0 \uc11c\uc220 \ub418\uc5b4 \uc788\uc9c0 \uc54a\ub2e4.<\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0);\"><br \/><\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0);\"><br \/><\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0);\">\uc77c\ubc18\uc801\uc73c\ub85c \uac04\ub2e8\ud55c \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c\ub294 \uba85\uc2dc\uc801 \ucc98\ub9ac\ub97c, \ucf54\ub4dc\ub77c\uc778\uc774 \ub9ce\uc740 \ud504\ub85c\uadf8\ub7a8\uc774\uac70\ub098 \ud300 \ucf54\ub529\uc744 \ud558\ub294 \uacbd\uc6b0\uc5d0\ub294 \ubb35\uc2dc\uc801 \ucc98\ub9ac\ub97c \uc120\ud638\ud558\ub294 \ud3b8\uc774\ub2e4.<\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0);\"><br \/><\/span><\/p><p style=\"margin-left: 8em; text-align: center; \"><span style=\"color: rgb(217, 65, 197); font-weight: bold; text-align: center; \">\u203b \uba85\uc2dc\uc801 \uc624\ub958 \ucc98\ub9ac\uc640 \ubb35\uc2dc\uc801 \uc624\ub958 \ucc98\ub9ac \ube44\uad50<\/span><\/p><p style=\"margin-left: 8em; text-align: center; \"><br \/><\/p><p style=\"margin-left: 8em; text-align: center; clear: none; float: none;\"><img decoding=\"async\" editor_component=\"image_link\" src=\"\/blog\/wp-content\/uploads\/cms_xe\/img0338.png\" alt=\"\" \/><\/p><p style=\"margin-left: 8em; text-align: center; \"><br \/><\/p><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0);\"><br \/><\/span><\/p><p style=\"margin-left: 8em; \"><span style=\"color: rgb(0, 0, 0);\">\ubb35\uc2dc\uc801\/\uba85\uc2dc\uc801 \uc624\ub958 \ucc98\ub9ac\uc758 \uc2e4\uc81c \uc0ac\uc6a9 \uc608\uc81c\ub294 28~ 34 page \ucc38\uc870.<\/span><\/p><p style=\"margin-left: 8em; \"><br \/><\/p><p style=\"margin-left: 8em; \">!! \uac1c\ubc1c\uc758 \ud544\uc218 \ub355\ubaa9\uc774 \uc624\ub958 \ucc98\ub9ac\ub77c\ub294 \uac83\uc744 \uaf2d \uba85\uc2ec\ud558\uc790.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ucd9c\ucc98 : http:\/\/blog.daum.net\/miracle_jhw\/14 1\uc7a5. &nbsp;Pro*C \uc18c\uac1c\uc640 \uae30\ubcf8 \ud2b9\uc9d5 1-1. Pro*C \uac1c\uc694 SQL \ubb38\uc740 \uc808\ucc28\ud615 \uc5b8\uc5b4\uac00 \uc544\ub2c8\ub2e4. \uadf8\ub798\uc11c \uc624\ub77c\ud074\uc744 \ud3ec\ud568\ud55c \ub9ce\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 PL\/SQL\uc774\ub77c\ub294 \uc808\ucc28\ud615 \uc5b8\uc5b4\ub97c \uc81c\uacf5\ud55c\ub2e4. DBMS\uc758 \ubc84\uc804\uc774 \ub192\uc544\uc9c0\uba74\uc11c \uc774\uc804\uacfc \ub2e4\ub974\uac8c PL\/SQL\uc5d0\ub3c4 \ub2e4\uc591\ud55c \uae30\ub2a5\uc774 \ucd94\uac00\ub418\uc5c8\ub2e4. \uc608\ub97c \ub4e4\uba74, TCP\/IP, HTTP, FILE I\/O \ub4f1\uacfc \uac19\uc740 \uae30\ub2a5\uc774 \ucd94\uac00\ub418\uc5b4 \ub2e4\uc591\ud55c \ubc29\uc2dd\uc758 \ud504\ub85c\uadf8\ub798\ubc0d\uc774 \uac00\ub2a5\ud574\uc84c\ub2e4. \ud558\uc9c0\ub9cc \uc624\ub77c\ud074 \uc678\ubd80 \ud504\ub85c\uadf8\ub7a8\uacfc\uc758 \uc5f0\ub3d9 \ub4f1\uc5d0 \uc788\uc5b4\uc11c [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[10],"tags":[],"class_list":["post-510","post","type-post","status-publish","format-standard","hentry","category-computing_database"],"_links":{"self":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/510","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=510"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/510\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=510"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=510"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=510"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}