{"id":42561,"date":"2024-11-11T03:00:31","date_gmt":"2024-11-11T03:00:31","guid":{"rendered":"https:\/\/atmokpo.com\/w\/?p=42561"},"modified":"2024-11-26T06:35:05","modified_gmt":"2024-11-26T06:35:05","slug":"4-pro-c%ec%97%90%ec%84%9c-sql%ea%b3%bc-c-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ed%83%80%ec%9e%85-%eb%a7%a4%ed%95%91-%ec%84%a4%eb%aa%85-sql-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ed%83%80%ec%9e%85%ea%b3%bc-c-%eb%8d%b0","status":"publish","type":"post","link":"https:\/\/atmokpo.com\/w\/42561\/","title":{"rendered":"4.Pro C\uc5d0\uc11c SQL\uacfc C \ub370\uc774\ud130 \ud0c0\uc785 \ub9e4\ud551, \uc124\uba85 SQL \ub370\uc774\ud130 \ud0c0\uc785\uacfc C \ub370\uc774\ud130 \ud0c0\uc785 \uac04\uc758 \ub9e4\ud551 \ubc29\ubc95\uc744 \uc124\uba85"},"content":{"rendered":"

<\/p>\n

Pro*C\ub294 Oracle\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 C \ud504\ub85c\uadf8\ub798\ubc0d \uc5b8\uc5b4 \uac04\uc758 \uc778\ud130\ud398\uc774\uc2a4\ub97c \uc81c\uacf5\ud558\ub294 \uc5b8\uc5b4\uc785\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 C \uac1c\ubc1c\uc790\ub294 SQL \ubb38\uc744 \uc9c1\uc811 C \ucf54\ub4dc\uc640 \ud63c\ud569\ud558\uc5ec \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubcf8 \ubb38\uc11c\uc5d0\uc11c\ub294 Pro*C\uc5d0\uc11c SQL \ub370\uc774\ud130 \ud0c0\uc785\uacfc C \ub370\uc774\ud130 \ud0c0\uc785 \uac04\uc758 \ub9e4\ud551 \ubc29\ubc95\uc744 \uc790\uc138\ud788 \uc0b4\ud3b4\ubcf4\uace0, \uc608\uc81c\ub97c \ud1b5\ud574 \uc774\ud574\ub97c \ub3d5\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n

1. \ub370\uc774\ud130 \ud0c0\uc785 \ub9e4\ud551 \uac1c\uc694<\/h2>\n

SQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \ub2e4\uc591\ud55c \ub370\uc774\ud130 \ud0c0\uc785\uc744 \uc9c0\uc6d0\ud558\uba70, C \ud504\ub85c\uadf8\ub798\ubc0d \uc5b8\uc5b4 \ub610\ud55c \uc790\uccb4\uc801\uc778 \ub370\uc774\ud130 \ud0c0\uc785\uc744 \uac00\uc9c0\uace0 \uc788\uc2b5\ub2c8\ub2e4. Pro*C\ub97c \uc0ac\uc6a9\ud558\uba74 SQL\uc758 \ub370\uc774\ud130 \ud0c0\uc785\uc744 C\uc758 \ub370\uc774\ud130 \ud0c0\uc785\uc73c\ub85c \ubcc0\ud658\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c \ub9e4\ud551\uc744 \ud1b5\ud574 SQL \ucffc\ub9ac\ub97c \uc2e4\ud589\ud558\uace0 \uacb0\uacfc\ub97c C \ubcc0\uc218\uc5d0 \uc800\uc7a5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

2. SQL\uacfc C \ub370\uc774\ud130 \ud0c0\uc785 \ub9e4\ud551 \ud45c<\/h2>\n\n\n\n\n\n\n\n\n
SQL \ub370\uc774\ud130 \ud0c0\uc785<\/th>\nC \ub370\uc774\ud130 \ud0c0\uc785<\/th>\n\uc124\uba85<\/th>\n<\/tr>\n<\/thead>\n
CHAR(n)<\/td>\nchar[n]<\/td>\n\uace0\uc815 \uae38\uc774 \ubb38\uc790\uc5f4<\/td>\n<\/tr>\n
VARCHAR2(n)<\/td>\nchar[n]<\/td>\n\uac00\ubcc0 \uae38\uc774 \ubb38\uc790\uc5f4<\/td>\n<\/tr>\n
NUMBER(p,s)<\/td>\nint \ub610\ub294 float<\/td>\n\uc22b\uc790 \ud0c0\uc785, p=\uc804\uccb4 \uc790\ub9ac\uc218, s=\uc18c\uc218\uc810 \uc774\ud558 \uc790\ub9ac\uc218<\/td>\n<\/tr>\n
DATE<\/td>\nstruct tm<\/td>\n\ub0a0\uc9dc\uc640 \uc2dc\uac04\uc744 \uc800\uc7a5\ud558\ub294 \ub370\uc774\ud130 \uad6c\uc870\uccb4<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

3. \ub370\uc774\ud130 \ud0c0\uc785 \ub9e4\ud551\uc758 \uc911\uc694\uc131<\/h2>\n

\uc801\uc808\ud55c \ub370\uc774\ud130 \ud0c0\uc785 \ub9e4\ud551\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uac04\uc758 \uc6d0\ud65c\ud55c \ub370\uc774\ud130 \uc804\uc1a1\uacfc \ucc98\ub9ac\uc5d0 \ub9e4\uc6b0 \uc911\uc694\ud569\ub2c8\ub2e4. \uc798\ubabb\ub41c \ub9e4\ud551\uc740 \ub370\uc774\ud130 \uc190\uc2e4 \ub610\ub294 \ubcc0\ud615\uc744 \ucd08\ub798\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub610\ud55c, \uc131\ub2a5 \uc800\ud558 \ubb38\uc81c\ub97c \ubc1c\uc0dd\uc2dc\ud0ac \uc218 \uc788\uc73c\ubbc0\ub85c, C \uac1c\ubc1c\uc790\ub294 \ub370\uc774\ud130 \ud0c0\uc785 \ub9e4\ud551\uc744 \uc815\ud655\ud788 \uc774\ud574\ud558\uace0 \uc0ac\uc6a9\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n

4. C\uc5d0\uc11c SQL \ub370\uc774\ud130 \ud0c0\uc785 \uc0ac\uc6a9\ud558\uae30<\/h2>\n

\uc774\uc81c Pro*C\uc5d0\uc11c SQL \ub370\uc774\ud130 \ud0c0\uc785\uc744 C \ubcc0\uc218\ub85c \uc0ac\uc6a9\ud558\uac70\ub098 \ubc18\ub300\ub85c \ub9e4\ud551\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud55c \uad6c\uccb4\uc801\uc778 \uc608\uc81c\ub97c \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n

\uc608\uc81c 1: CHAR \ub370\uc774\ud130 \ud0c0\uc785 \uc0ac\uc6a9\ud558\uae30<\/h3>\n
\n

SQL \ud14c\uc774\ube14 \uc815\uc758<\/h4>\n
\nCREATE TABLE employees (\n    employee_id NUMBER,\n    first_name CHAR(20),\n    last_name CHAR(20)\n);\n        <\/pre>\n
Pro*C \ucf54\ub4dc \uc608\uc81c<\/h4>\n
\n#include \n#include \n\nvoid main() {\n    EXEC SQL BEGIN DECLARE SECTION;\n    long emp_id;\n    char first_name[20];\n    char last_name[20];\n    EXEC SQL END DECLARE SECTION;\n\n    EXEC SQL SELECT employee_id, first_name, last_name\n             INTO :emp_id, :first_name, :last_name\n             FROM employees\n             WHERE employee_id = 1;\n\n    printf(\"ID: %ld, First Name: %s, Last Name: %s\\n\", emp_id, first_name, last_name);\n}\n        <\/stdio.h><\/sqlca.h><\/pre>\n<\/div>\n
\uc608\uc81c 2: NUMBER \ub370\uc774\ud130 \ud0c0\uc785 \uc0ac\uc6a9\ud558\uae30<\/h3>\n
\n
SQL \ud14c\uc774\ube14 \uc815\uc758<\/h4>\n
\nCREATE TABLE salaries (\n    employee_id NUMBER,\n    salary NUMBER(10,2)\n);\n        <\/pre>\n
Pro*C \ucf54\ub4dc \uc608\uc81c<\/h4>\n
\n#include \n#include \n\nvoid main() {\n    EXEC SQL BEGIN DECLARE SECTION;\n    long emp_id;\n    float salary;\n    EXEC SQL END DECLARE SECTION;\n\n    EXEC SQL SELECT employee_id, salary\n             INTO :emp_id, :salary\n             FROM salaries\n             WHERE employee_id = 1;\n\n    printf(\"ID: %ld, Salary: %.2f\\n\", emp_id, salary);\n}\n        <\/stdio.h><\/sqlca.h><\/pre>\n<\/div>\n
\uc608\uc81c 3: DATE \ub370\uc774\ud130 \ud0c0\uc785 \uc0ac\uc6a9\ud558\uae30<\/h3>\n
\n
SQL \ud14c\uc774\ube14 \uc815\uc758<\/h4>\n
\nCREATE TABLE employees (\n    employee_id NUMBER,\n    hire_date DATE\n);\n        <\/pre>\n
Pro*C \ucf54\ub4dc \uc608\uc81c<\/h4>\n
\n#include \n#include \n#include \n\nvoid main() {\n    EXEC SQL BEGIN DECLARE SECTION;\n    long emp_id;\n    struct tm hire_date;\n    EXEC SQL END DECLARE SECTION;\n\n    EXEC SQL SELECT employee_id, hire_date\n             INTO :emp_id, :hire_date\n             FROM employees\n             WHERE employee_id = 1;\n\n    printf(\"ID: %ld, Hire Date: %04d-%02d-%02d\\n\", emp_id, hire_date.tm_year + 1900, hire_date.tm_mon + 1, hire_date.tm_mday);\n}\n        <\/time.h><\/stdio.h><\/sqlca.h><\/pre>\n<\/div>\n
5. \uacb0\ub860<\/h2>\n
Pro*C\uc5d0\uc11c SQL\uacfc C \ub370\uc774\ud130 \ud0c0\uc785 \uac04\uc758 \ub9e4\ud551\uc740 Oracle \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc720\uc6a9\ud568\uc744 C \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0\uc11c \uc27d\uac8c \uc0ac\uc6a9\ud560 \uc218 \uc788\uac8c \ud574\uc90d\ub2c8\ub2e4. SQL \ub370\uc774\ud130 \ud0c0\uc785\uc744 C \ub370\uc774\ud130 \ud0c0\uc785\uc73c\ub85c \uc815\ud655\ud558\uac8c \ub9e4\ud551\ud558\ub294 \uac83\uc740 \uc62c\ubc14\ub978 \ub370\uc774\ud130 \ucc98\ub9ac\uc640 \ud6a8\uc728\uc801\uc778 \ud504\ub85c\uadf8\ub7a8 \uc791\uc131\uc744 \uc704\ud574 \ud544\uc218\uc801\uc785\ub2c8\ub2e4. \uc774 \ubb38\uc11c\ub97c \ud1b5\ud574 SQL\uacfc C \uac04\uc758 \ub9e4\ud551 \ubc29\uc2dd\uc744 \uc774\ud574\ud558\uace0, Pro*C\ub97c \ud1b5\ud574 \uc2e4\uc81c\ub85c \ub370\uc774\ud130\ub97c \ucc98\ub9ac\ud558\ub294 \ubc29\ubc95\uc744 \uc775\ud790 \uc218 \uc788\uae30\ub97c \ubc14\ub78d\ub2c8\ub2e4.<\/p>\n