{"id":393,"date":"2024-07-08T05:32:42","date_gmt":"2024-07-08T05:32:42","guid":{"rendered":"https:\/\/the.2days.kr\/?p=393"},"modified":"2024-07-08T05:32:42","modified_gmt":"2024-07-08T05:32:42","slug":"sql-%ea%b8%b0%ec%b4%88-%eb%ac%b8%eb%b2%95-%ec%a0%95%eb%a6%ac","status":"publish","type":"post","link":"https:\/\/the.2days.kr\/?p=393","title":{"rendered":"SQL \uae30\ucd08 \ubb38\ubc95 \uc815\ub9ac"},"content":{"rendered":"
\n

\n
\n
\n<\/span>
\n SQL \ub85c\uace0(SQL LOGO)
\n <\/figcaption><\/figure>\n<\/p>\n

\n
\n SQL(Structured Query Language)\uc774\ub780?
\n <\/b>\n<\/p>\n

\n SQL\uc740 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc870\uc791\uacfc \uad00\ub9ac\uc5d0 \uc0ac\uc6a9\ub418\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc9c8\uc758\uc6a9 \uc5b8\uc5b4\uc785\ub2c8\ub2e4. 1970\ub144\ub300 IBM \ud68c\uc0ac\uc5d0 \uc758\ud558\uc5ec \uac1c\ubc1c\ub418\uc5c8\uace0, IBM\uc758 \uad00\uacc4\ud615 DBMS\uc5d0\uc11c \ucc98\uc74c \uc0ac\uc6a9\ub410\uc2b5\ub2c8\ub2e4. \uc774\ud6c4 1986\ub144 \ubbf8\uad6d\ud45c\uc900\ud611\ud68c(ANSI)\uac00 SQL \ud45c\uc900\uc744 \ucc44\ud0dd\ud568\uc5d0 \ub530\ub77c \ud604\uc7ac\ub294 IBM\uc758 DB2, \ub9c8\uc774\ud06c\ub85c\uc18c\ud504\ud2b8\uc758 Access\uc640 SQL Server\ub97c \ube44\ub86f\ud558\uc5ec Oracle, Sybase, Informix \ub4f1\uc5d0\uc11c \uad6c\uc870\ud654 \uc9c8\uc758\uc5b4\ub85c \ub110\ub9ac \uc0ac\uc6a9\ub418\uace0 \uc788\uc2b5\ub2c8\ub2e4. SQL\uc740 \uc6d0\ud558\ub294 \ub370\uc774\ud130\uac00 \ubb34\uc5c7(What)\uc778\uc9c0\ub9cc \uae30\uc220\ud558\uace0, \uac80\uc0c9 \ubc29\ubc95(How)\uc740 \uae30\uc220\ud558\uc9c0 \uc54a\uc73c\ubbc0\ub85c \ube44\uc808\ucc28\uc801 \uc5b8\uc5b4\uc785\ub2c8\ub2e4. \uc774\ub7ec\ud55c \ud2b9\uc131 \ub54c\ubb38\uc5d0 SQL\uc740 \uc0c1\ub300\uc801\uc73c\ub85c \ubc30\uc6b0\uae30 \uc27d\uace0 \uc790\uc5f0\uc5b4\uc5d0 \uac00\uae4c\uc6b4 \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud574 \uc9c8\uc758\ub97c \ud45c\ud604\ud558\uae30 \ub54c\ubb38\uc5d0 \uad00\uacc4\ud615 \ub300\uc218\ub098 \uad00\uacc4\ud615 \ud574\uc11d\ubcf4\ub2e4 \ud45c\ud604\ub825\uc774 \uc6b0\uc218\ud569\ub2c8\ub2e4.\n <\/p>\n

\n

\n SQL\uc740 \uc544\ub798\uc640 \uac19\uc774 3\uac00\uc9c0 \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.\n <\/p>\n

\n 1. \ub370\uc774\ud130 \uc815\uc758 \uae30\ub2a5 : \ub370\uc774\ud130 \uc815\uc758\uc5b4(DDL)\ub97c \uc774\uc6a9\ud558\uc5ec \ub9b4\ub808\uc774\uc158\uc758 \uc0dd\uc131 \ubc0f \uc81c\uac70, \uc18d\uc131\uc758 \ucd94\uac00 \ubc0f \uc0ad\uc81c, \ubdf0\uc758 \uc0dd\uc131 \ubc0f \uc81c\uac70, \uc778\ub371\uc2a4\uc758 \uc0dd\uc131 \ubc0f \uc81c\uac70 \ub4f1\uc758 \uc791\uc5c5\uc744 \uc218\ud589\ud569\ub2c8\ub2e4. \ub610\ud55c \ub9b4\ub808\uc774\uc158 \uc0dd\uc131 \uc2dc \uc5ec\ub7ec \uac00\uc9c0 \ubb34\uacb0\uc131 \uc81c\uc57d \uc870\uac74\ub4e4\uc744 \uae30\uc220\ud569\ub2c8\ub2e4.\n <\/p>\n

\n 2. \ub370\uc774\ud130 \uc870\uc791 \uae30\ub2a5 : \ub370\uc774\ud130 \uc870\uc791\uc5b4(DML)\ub97c \uc774\uc6a9\ud558\uc5ec \ub370\uc774\ud130\uc758 \uac80\uc0c9, \uc0bd\uc785, \uc0ad\uc81c, \uc218\uc815 \ub4f1\uc758 \uc5f0\uc0b0\uc744 \uc218\ud589\ud569\ub2c8\ub2e4.\n <\/p>\n

\n 3. \ub370\uc774\ud130 \uc81c\uc5b4 \uae30\ub2a5 : \ub370\uc774\ud130 \uc81c\uc5b4\uc5b4(DCL)\ub97c \uc774\uc6a9\ud558\uc5ec \ud2b8\ub79c\uc7ad\uc158\uc758 \uc2dc\uc791, \ucca0\ud68c, \uc644\ub8cc \ub4f1\uc744 \uba85\uc2dc\ud558\uace0, \ub9b4\ub808\uc774\uc158\uc5d0 \ub300\ud574 \uad8c\ud55c\uc744 \ubd80\uc5ec\ud558\uac70\ub098 \ucde8\uc18c\ud569\ub2c8\ub2e4.\n <\/p>\n

\n

\n

\n
\n SQL \uc124\uba85
\n <\/b>
\n
\n<\/b>\n<\/p>\n

\n \uc774 \uc9c1\uad00\uc801\uc778 \uc5b8\uc5b4\ub294 \uc5b4\ub290 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c\ub098 \uae30\ubcf8\uc73c\ub85c \uc81c\uacf5\ud558\uae30 \ub54c\ubb38\uc5d0 \ubc30\uc6cc\ub450\uba74 \uc5ec\ub7ec \uacf3\uc5d0\uc11c \uc4f8\ub370\uac00 \ub9ce\uc2b5\ub2c8\ub2e4. \ub2e4\ub9cc, NoSQL \uacc4\uc5f4\uc5d0\uc11c\ub294 SQL \ubb38\uc744 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098 DBMS \ubca4\ub354\uc5d0 \ub530\ub77c \uc0ac\uc6a9\ud558\ub294 SQL\uc5d0\ub294 \ub2e4\uc18c \ucc28\uc774\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub798\uc11c ANSI SQL\uc774\ub77c\uace0 \ud558\ub294 \ud45c\uc900 SQL \uad6c\ubb38\uc774 \uc788\uc73c\ub098 DBMS \uc2dc\uc7a5\uc744 \ub3c5\uc2dd\ud558\uace0 \uc788\ub294 \uc624\ub77c\ud074\uc774 \uc798 \uc9c0\ud0a4\uc9c0 \uc54a\uae30 \ub54c\ubb38\uc5d0 \ud604\uc2e4\uc740 \ud798\ub4e0 \uc0c1\ud669\uc774\ub77c\uace0 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ucd5c\uadfc \uc778\uae30\ub97c \uc5bb\uace0 \uc788\ub294 PostgreSQL\uc740 \ud45c\uc900 SQL\uc744 \uc798 \uc9c0\ud0a4\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uc77c\ubc18\uc801\uc73c\ub85c \uc0ac\uc6a9\ud558\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 RDB(\uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4)\uc774\uba70, RDB\uc5d0\uc11c \ub370\uc774\ud130 \ucc98\ub9ac\ub294 \ub370\uc774\ud130 \ubaa8\uc74c\uc778 \ud14c\uc774\ube14\uc744 \uae30\uc900\uc73c\ub85c \uc774\ub8e8\uc5b4\uc9c0\uae30 \ub54c\ubb38\uc5d0 SQL \uc5ed\uc2dc \ud14c\uc774\ube14\uc744 \uc5fc\ub450\uc5d0 \ub450\uace0 \uc77d\uc73c\uba74 \uc774\ud574\ud558\uae30 \uc27d\uc2b5\ub2c8\ub2e4.\n <\/p>\n

\n

\n SQL\uc740 \ub300\uc18c\ubb38\uc790\ub97c \uad6c\ubd84\ud558\uc9c0 \uc54a\uc73c\ubbc0\ub85c ‘SELECT’\uc640 ‘select’\ub294 \uac19\uc740 \uac83\uc73c\ub85c \ucde8\uae09\ub429\ub2c8\ub2e4. \ubb3c\ub860 \ub530\uc634\ud45c\ub85c \uc778\uc6a9\ub41c ‘\uac12’\uc740 \ub300\uc18c\ubb38\uc790\ub97c \uad6c\ubd84\ud569\ub2c8\ub2e4. \ubb38\uc790\uc5f4\uc744 \ub300\uc18c\ubb38\uc790\ub97c \uad6c\ubd84\ud558\uc9c0 \uc54a\uac8c \ud558\ub824\uba74 \uba85\ub839 \ub9e8 \ub4a4\uc5d0 ‘COLLATE NOCASE’\ub97c \ubd99\uc785\ub2c8\ub2e4. \ub610\ud55c \ub300\ubd80\ubd84\uc758 DBMS\ub294 \uc138\ubbf8\ucf5c\ub860(;)\uc744 \uc785\ub825\ud558\uc9c0 \uc54a\uc73c\uba74 \uba85\ub839\uc5b4\ub97c \uacc4\uc18d \uc785\ub825\ud558\uace0 \uc788\ub2e4\uace0 \uac04\uc8fc\ud569\ub2c8\ub2e4. GUI\ub97c \uc0ac\uc6a9\ud560 \uacbd\uc6b0 GUI\ud504\ub860\ud2b8\uc5d4\ub4dc\uc5d0\uc11c \uc54c\uc544\uc11c \uc138\ubbf8\ucf5c\ub860\uc744 \ubd99\uc5ec \uc8fc\uae30 \ub54c\ubb38\uc5d0 \uc798 \ubaa8\ub974\uace0 \ub118\uc5b4\uac08 \uc218 \uc788\ub294\ub370 \ud130\ubbf8\ub110\ub85c \uc791\uc5c5\ud560 \uacbd\uc6b0\uc5d0\ub294 \uc774\uac83 \ub54c\ubb38\uc5d0 \uc178\uc774 \uba39\ud1b5\uc774 \ub418\ub294 \uacbd\uc6b0\uac00 \uc788\uc2b5\ub2c8\ub2e4.\n <\/p>\n

\n

\n \uadf8\ub9ac\uace0 \ucffc\ub9ac\ub97c \uc5f0\uc2b5\ud560 \ub54c \uc8fc\uc758\ud560 \uc810\uc774 \ud55c \uac00\uc9c0 \uc788\ub294\ub370 SQL \uad6c\ubb38\uc740 \ud0d0\uc695\uc2a4\ub7fd\uc2b5\ub2c8\ub2e4(Greedy). SQL\uc740 \uac00\ub2a5\ud55c \ub113\uc740 \ubc94\uc704\uc5d0 \uac78\uccd0 \uc791\uc5c5\ud558\ub824\uace0 \ud569\ub2c8\ub2e4. \ub530\ub77c\uc11c ‘WHERE’\uc808\uc774\ub098 ‘LIMIT’ \uad6c\ubb38\uc744 \uc0dd\ub7b5\ud558\uba74 ‘SELECT’\uc758 \uacbd\uc6b0 \ub05d\ub3c4 \uc5c6\uc774 \ucd9c\ub825\ud558\ub294 \ub808\ucf54\ub4dc \uc5f4\uc744 \ubcf4\uac8c \ub420 \uac83\uc774\uace0 UPDATE\uc640 DELETE\uc758 \uacbd\uc6b0 \uc0ac\ubcf4\ud0c0\uc8fc\uc5d0 \uac00\uae4c\uc6b4 \uad11\uc5ed \ubcc0\uc870(\ud30c\uad34)\uac00 \uc77c\uc5b4\ub0a9\ub2c8\ub2e4. \ub610\ud55c \ub300\ubd80\ubd84\uc758 DBMS\uc5d0\uc11c\ub294 \ud2b8\ub79c\uc7ad\uc158 BEGIN\uc744 \uba3c\uc800 \uac78\uace0 \uc791\uc5c5\ud558\uc9c0 \uc54a\ub294 \ud55c \uc791\uc5c5\uc744 \ucde8\uc18c(UNDO)\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. \ub2e4\uc2dc \ub9d0\ud558\uc5ec ‘BEGIN’\uc744 \uc785\ub825\ud558\uc9c0 \uc54a\uace0 ‘DELETE from table;’\uc744 \uc785\ub825\ud55c \uacbd\uc6b0 ‘ROLLBACK’ \uba85\ub839\uc744 \uc785\ub825\ud574\ub3c4 \uc18c\uc6a9\uc774 \uc5c6\uc2b5\ub2c8\ub2e4. \uac00\uc7a5 \uce58\uba85\uc801\uc778 \uc624\ud0c0\ub85c ‘WHERE’\uc808 \uc785\ub825 \uc9c1\uc804\uc5d0 \ub530\uc634\ud45c\ub97c \ub2eb\ub294\ub2e4\ub294 \uac8c \ubc14\ub85c \uc606\uc758 \uc138\ubbf8\ucf5c\ub860\uc744 \uc798\ubabb \uccd0\uc11c \uc624\ud0c0\ub97c \ub0b8 \uacbd\uc6b0\uac00 \uadf8 \uc608\uc785\ub2c8\ub2e4. \uc774 \uacbd\uc6b0 \uc55e\uc758 \uba85\ub839\uc5b4\ub97c \ubaa8\ub4e0 \ub808\ucf54\ub4dc\uc5d0 \ub300\ud574 \uc218\ud589\ud574\uc11c \ud14c\uc774\ube14\uc744 \ud30c\uad34\ud574 \ubc84\ub9b0 \ub4a4\uc5d0 \ub4a4\ucabd \uba85\ub839\uc5b4\ub97c ‘\ubb38\ubc95 \uc624\ub958’\ub85c \ucd9c\ub825\ud569\ub2c8\ub2e4.\n <\/p>\n

\n

\n \ub530\ub77c\uc11c ‘UPDATE’, ‘DELETE’\ub97c \uc2e4\ud589\ud574\ubcf4\uae30 \uc804\uc5d0\ub294 \ubc18\ub4dc\uc2dc ‘BEGIN’\uc744 \uc785\ub825\ud558\uc5ec \ud2b8\ub79c\uc7ad\uc158\uc744 \uc2dc\uc791\ud55c \ub4a4\uc5d0 \ud574\ub2f9 \ucffc\ub9ac\ub97c \uc2e4\ud589\ud558\uace0, \uc2e4\ud589 \uacb0\uacfc\uac00 \uc758\ub3c4\ud55c \ub300\ub85c\uc778\uc9c0\ub97c SELECT\ub85c \uac80\uc99d\ud55c \ub4a4\uc5d0 \uc758\ub3c4\ud55c \uacb0\uacfc\ub300\ub85c \ucffc\ub9ac\uac00 \uc218\ud589\ub418\uc5c8\uc74c\uc744 \ud655\uc778\ud558\uace0 \ub098\uc11c, ‘COMMIT’\uc744 \uc785\ub825\ud558\uc5ec \ud2b8\ub79c\uc7ad\uc158\uc744 \uc801\uc6a9\ud558\ub294 \uc2b5\uad00\uc744 \ub4e4\uc774\ub294 \uac8c \uc88b\uc2b5\ub2c8\ub2e4. \ub9cc\uc57d \ubb54\uac00\uac00 \uc798\ubabb\ub418\uc5c8\uc744 \uacbd\uc6b0 \uc989\uc2dc ‘ROLLBACK’ \uba85\ub839\uc744 \uc785\ub825\ud558\uba74 ‘BEGIN’\uc744 \uc785\ub825\ud55c \ub4a4\uc5d0 \ud589\ud55c \ubaa8\ub4e0 \uc791\uc5c5\uc774 \ucde8\uc18c\ub429\ub2c8\ub2e4. GUI\uc758 \uacbd\uc6b0\uc5d0\ub294 \uc5ec\ub7ec \ucffc\ub9ac\ub97c \uc785\ub825\ud588\uc744 \uacbd\uc6b0 \ub9c8\uc9c0\ub9c9 ‘SELECT’\uc758 \uacb0\uacfc\ub97c \ubcf4\uc5ec\uc8fc\ub294 \uae30\ub2a5\uc774 \ud0d1\uc7ac\ub418\uc5b4 \uc788\ub2e4\ub294 \uc804\uc81c \uc544\ub798 \ucc98\uc74c\ubd80\ud130 ‘BEGIN; ~ ROLLBACK;’ \ube14\ub85d\uc744 \ubbf8\ub9ac \uc785\ub825\ud574 \ub450\uace0 \uc791\uc5c5\uc744 \ud558\ub294 \uac8c \uc548\uc804\ud569\ub2c8\ub2e4.\n <\/p>\n

\n

\n \uc77c\ub2e8 SQL\uc744 \uc785\ub825\ud560 \ub54c\uc5d0\ub294 \uc808\ub300 \ud568\ubd80\ub85c \uc5d4\ud130\ud0a4\ub97c \ub20c\ub7ec\uc120 \uc548 \ub429\ub2c8\ub2e4. \uc9c0\uc801\ud655\uc778\uc744 \ud558\ub294 \uac8c \ub3c4\uc6c0\uc774 \ub420 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. \ud2b9\ud788 ‘WHERE’\uc808 \uc55e\ub4a4\ub97c \ub9e4\uc6b0 \uaf3c\uaf3c\ud558\uac8c \uc0b4\ud3b4\uc57c \ud558\uace0 ‘WHERE’\uc808\uc774 \uc5c6\ub294 \ucffc\ub9ac\ub294 \ubb34\uc870\uac74 \ud2c0\ub838\ub2e4\uace0 \uac04\uc8fc\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4. SQL\uc740 \uae30\ubcf8\uac12\uc774 ‘rm -rf \/’\ub77c\uace0 \uc0dd\uac01\ud558\ub294 \uac8c \ud3b8\ud569\ub2c8\ub2e4. \uc544\uc608 \ub0a0\ucffc\ub9ac\ub97c \ud568\ubd80\ub85c \ub123\uc9c0 \ub9d0\ub77c\uace0 \ud504\ub85c\uc2dc\uc800(Procedure)\ub77c\ub294 \ucffc\ub9ac \ud15c\ud50c\ub9bf \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \ucc38\uace0\ub85c SQL\uacfc PL\/SQL\uc740 \ub2e4\ub978 \uac83\uc778\ub370, PL\/SQL\uc774 SQL\uc744 \ud3ec\ud568\ud558\uace0 \uc788\uae30\ub294 \ud558\uc9c0\ub9cc SQL\uc744 \uc790\uc720\uc790\uc7ac\ub85c \uc4f8 \uc815\ub3c4\uc758 \uc2e4\ub825\uc774 \ub418\uc9c0 \uc54a\uc558\ub294\ub370 PL\/SQL\uc744 \uacf5\ubd80\ud558\uba74 \uc548 \ub429\ub2c8\ub2e4. \uae08\uc735\uacc4\uc5d0\uc11c\ub294 PL\/SQL\uc744 \ub110\ub9ac \uc4f0\ub2c8\uae4c \uc740\ud589\uc5d0 \uac1c\ubc1c\uc790\ub85c \ucde8\uc5c5\ud558\ub824\uba74 \uaf2d \ubc30\uc6cc\uc57c \ud558\uc9c0\ub9cc \ubc30\uc6b8 \ub54c \ubc30\uc6b0\ub354\ub77c\ub3c4 SQL\uc744 \uc790\uc2e0 \uc788\uac8c \ub2e4\ub8f0 \uc218 \uc788\uac8c \ub41c \ub2e4\uc74c\uc758 \uc77c\uc785\ub2c8\ub2e4. \uc9c4\ub3c4\ub97c \ube68\ub9ac \ube7c\uace0 \uc2f6\uc740 \uc695\uc2ec\uc5d0 SQL\ub3c4 \ubaa8\ub974\ub294 \ucc44\ub85c PL\/SQL\uc5d0 \ub3c4\uc804\ud588\ub2e4\uac04 \uae30\uc874\uc5d0 \uacf5\ubd80\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc774\ub860\uccb4\uacc4\uc5d0 \ud63c\ub3d9\uc744 \uc77c\uc73c\ucf1c \uc624\ud788\ub824 \uc9c4\ub3c4\uac00 \ub4a4\ub85c \ud6c4\ud1f4\ud569\ub2c8\ub2e4.\n <\/p>\n

\n

\n
\n SQL\uc758 \uc5ed\uc0ac\uc640 \uc124\uacc4
\n <\/b>\n<\/p>\n

\n SQL\uc740 IBM\uc5d0\uc11c 1970\ub144\ub300 \ucd08\uc5d0 \ub3c4\ub110\ub4dc D. \ucc54\ubc8c\ub9b0\uacfc \ub808\uc774\uba3c\ub4dc F. \ubcf4\uc774\uc2a4\uac00 \ucc98\uc74c \uac1c\ubc1c\ud558\uc600\uc2b5\ub2c8\ub2e4. \ucd08\uae30\uc5d0\ub294 SEQUEL(Structured English Query Language – \uad6c\uc870 \uc601\uc5b4 \uc9c8\uc758\uc5b4)\ub77c\ub294 \uc774\ub984\uc73c\ub85c \uc2dc\uc791\ud558\uc600\uc73c\uba70, IBM\uc758 \uc900 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c \uc2dc\uc2a4\ud15c R\uc5d0 \uc800\uc7a5\ub41c \ub370\uc774\ud130\ub97c \uc870\uc791\ud558\uace0 \uc218\uc2e0\ud558\uae30 \uc704\ud574 \uace0\uc548\ub418\uc5c8\uc2b5\ub2c8\ub2e4. SEQUEL\uc740 \ub098\uc911\uc5d0 SQL\ub85c \ubc14\ub00c\uc5c8\ub294\ub370, \uadf8 \uae4c\ub2ed\uc740 SEQUEL\uc774 \uc601\uad6d\uc758 \ud638\ucee4 \uc2dc\ub4e4\ub9ac \ud56d\uacf5\uc0ac\uc758 \uc0c1\ud45c\uc600\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. SQL\uc740 \uad00\uacc4\ud615 \ubaa8\ub378\uacfc \uadf8\uac83\uc758 \ud29c\ud50c \ud574\uc11d\uc774\ub77c\ub294 \uc774\ub860\uc801 \uae30\ucd08\ub85c\ubd80\ud130 \ud30c\uc0dd\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \ud574\ub2f9 \ubaa8\ub378\uc5d0\uc11c \ud14c\uc774\ube14\uc740 \ud29c\ud50c\uc758 \uc9d1\ud569\uc774\uc9c0\ub9cc, SQL\uc5d0\uc11c\ub294 \ud14c\uc774\ube14\uacfc \ucffc\ub9ac \uacb0\uacfc\ub294 \ud589(row)\uc758 \ubaa9\ub85d\uc785\ub2c8\ub2e4. \uac19\uc740 \ud589\uc740 \uc5ec\ub7ec \ubc88 \ubc1c\uc0dd\ud560 \uc218 \uc788\uace0 \ud589\uc758 \uc21c\uc11c\ub294 \ucffc\ub9ac\uc5d0 \uc758\ud574 \ub098\ud0c0\ub0a9\ub2c8\ub2e4. \uadf8 \uc608\ub85c\ub294 ‘LIMIT’ \uc808 \ub4f1\uc774 \uc788\uc2b5\ub2c8\ub2e4.\n <\/p>\n

\n

\n

\n
\n \uba85\ub839\uc5b4 \ubb38\ubc95 \uc815\ub9ac
\n <\/b>\n<\/p>\n

\n

\n
\n \ub370\uc774\ud130 \uc815\uc758 \uc5b8\uc5b4
\n <\/b>\n<\/p>\n

\n CREATE [\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uac1c\uccb4(\ud14c\uc774\ube14, \uc778\ub371\uc2a4, \uc81c\uc57d\uc870\uac74 \ub4f1)\uc758 \uc815\uc758]\n <\/p>\n

\n DROP(\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uac1c\uccb4 \uc0ad\uc81c)\n <\/p>\n

\n ALTER(\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uac1c\uccb4 \uc815\uc758 \ubcc0\uacbd)\n <\/p>\n

\n

\n \ub370\uc774\ud130 \uc815\uc758 \uc5b8\uc5b4\ub294 \ud14c\uc774\ube14\uacfc \uc778\ub371\uc2a4 \uad6c\uc870\ub97c \uad00\ub9ac\ud569\ub2c8\ub2e4. DDL\uc758 \uac00\uc7a5 \uae30\ubcf8\uc801\uc778 \uc694\uc18c\ub294 CREATE, ALTER, RENAME, DROP\uacfc TRUNCATE \uad6c\ubb38\uc785\ub2c8\ub2e4.\n <\/p>\n

\n

\n

\n
\n \ub370\uc774\ud130 \uc870\uc791 \uc5b8\uc5b4
\n <\/b>\n<\/p>\n

\n INSERT INTO(\ud589 \ub370\uc774\ud130 \ub610\ub294 \ud14c\uc774\ube14 \ub370\uc774\ud130\uc758 \uc0bd\uc785)\n <\/p>\n

\n UPDATE ~ SET(\ud45c \uc5c5\ub370\uc774\ud2b8)\n <\/p>\n

\n DELETE FROM(\ud14c\uc774\ube14\uc5d0\uc11c \ud2b9\uc815 \ud589 \uc0ad\uc81c)\n <\/p>\n

\n SELECT ~ FROM ~ WHERE(\ud14c\uc774\ube14 \ub370\uc774\ud130\uc758 \uac80\uc0c9 \uacb0\uacfc \uc9d1\ud569\uc758 \ucde8\ub4dd\n <\/p>\n

\n

\n
\n \ub370\uc774\ud130 \uc81c\uc5b4 \uc5b8\uc5b4
\n <\/b>\n<\/p>\n

\n GRANT(\ud2b9\uc815 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9\uc790\uc5d0\uac8c \ud2b9\uc815 \uc791\uc5c5\uc744 \uc218\ud589 \uad8c\ud55c \ubd80\uc5ec)\n <\/p>\n

\n REVOKE(\ud2b9\uc815 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc774\uc6a9\uc790\ub85c\ubd80\ud130 \uc774\ubbf8 \uc900 \uad8c\ud55c\uc744 \ubc15\ud0c8)\n <\/p>\n

\n SET TRANSACTION {\ud2b8\ub79c\uc7ad\uc158 \ubaa8\ub4dc \uc124\uc815[\ub3d9\uc2dc \ud2b8\ub79c\uc7ad\uc158 \uaca9\ub9ac \uc218\uc900(ISOLATION MODE) \ub4f1]}\n <\/p>\n

\n BEGIN(\ud2b8\ub79c\uc7ad\uc158 \uc2dc\uc791)\n <\/p>\n

\n COMMIT(\ud2b8\ub79c\uc7ad\uc158\uc758 \uc2e4\ud589)\n <\/p>\n

\n ROLLBACK(\ud2b8\ub79c\uc7ad\uc158 \ucde8\uc18c)\n <\/p>\n

\n SAVEPOINT(\ubb34\uc791\uc704\ub85c \ub864\ubc31 \uc9c0\uc810\uc744 \uc124\uc815)\n <\/p>\n

\n LOCK(TABLE \ub4f1\uc758 \uc790\uc6d0\uc744 \ucc28\uc9c0)\n <\/p>\n

\n

\n
\n \ucee4\uc11c \uc815\uc758 \ubc0f \uc0ac\uc6a9
\n <\/b>\n<\/p>\n

\n ‘\ucee4\uc11c’\ub294 SELECT \ubb38\uc7a5 \ub4f1\uc5d0 \uc758\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uac80\uc0c9\uc5d0 \uc758\ud55c \uac80\uc0c9 \uc2e4\ud589 \uacb0\uacfc\ub97c \ud55c \uc904\uc529 \uac80\uc0c9\ud558\uace0, \ucc98\ub9ac\ud558\uae30 \uc704\ud574 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84 \uce21\uc758 \uacb0\uacfc \uc9d1\ud569\uacfc \ud589 \ud68d\ub4dd \uc704\uce58\ub97c \ub098\ud0c0\ub0b4\ub294 \uac1c\ub150\uc744 \ub9d0\ud569\ub2c8\ub2e4. \ucee4\uc11c\uc758 \uc815\uc758\uc640 \uadf8 \uc791\uc5c5\uc740 \uc8fc\ub85c \uc751\uc6a9 \ud504\ub85c\uadf8\ub7a8 \ub4f1\uc758 \uc808\ucc28\uc801 \uc5b8\uc5b4\uc5d0\uc11c\uc758 SQL \uc2e4\ud589 \uc2dc \uc0ac\uc6a9\ud569\ub2c8\ub2e4.\n <\/p>\n

\n DECLARE CURSOR(\ucee4\uc11c \uc815\uc758)\n <\/p>\n

\n OPEN(\ucee4\uc11c \uc5f4\uae30)\n <\/p>\n

\n FETCH(\ucee4\uc11c \ud3ec\uc778\ud130\uac00 \uac00\ub9ac\ud0a4\ub294 \uc704\uce58\uc758 \ud589 \ub370\uc774\ud130\ub97c \uac80\uc0c9\ud558\uace0 \ud3ec\uc778\ud130\ub97c \uc77c\ud589 \ubd84 \uc9c4\ud589)\n <\/p>\n

\n UPDATE(\ucee4\uc11c \ud3ec\uc778\ud130\uac00 \uac00\ub9ac\ud0a4\ub294 \uc704\uce58\uc758 \ud589 \ub370\uc774\ud130 \uc5c5\ub370\uc774\ud2b8)\n <\/p>\n

\n DELETE(\ucee4\uc11c \ud3ec\uc778\ud130\uac00 \uac00\ub9ac\ud0a4\ub294 \uc704\uce58\uc758 \ud589 \ub370\uc774\ud130 \uc0ad\uc81c)\n <\/p>\n

\n CLOSE(\ucee4\uc11c \ub2eb\uae30)\n <\/p>\n

\n

\n
\n \uc5f0\uc0b0\uc790 \uc124\uba85
\n <\/b>\n<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n
\n \uc5f0\uc0b0\uc790\n <\/td>\n\n \uc124\uba85\n <\/td>\n<\/tr>\n
\n =\n <\/td>\n\n \uac19\uc74c\n <\/td>\n<\/tr>\n
\n <> \ub610\ub294 !=\n <\/td>\n\n \uac19\uc9c0 \uc54a\uc74c\n <\/td>\n<\/tr>\n
\n >\n <\/td>\n\n \ubcf4\ub2e4 \ud07c\n <\/td>\n<\/tr>\n
\n <\n <\/td>\n\n \ubcf4\ub2e4 \uc791\uc74c\n <\/td>\n<\/tr>\n
\n >=\n <\/td>\n\n \ubcf4\ub2e4 \ud06c\uac70\ub098 \uac19\uc74c\n <\/td>\n<\/tr>\n
\n <=\n <\/td>\n\n \ubcf4\ub2e4 \uc791\uac70\ub098 \uac19\uc74c\n <\/td>\n<\/tr>\n
\n BETWEEN\n <\/td>\n\n \uc77c\uc815 \ubc94\uc704 \uc0ac\uc774\n <\/td>\n<\/tr>\n
\n LIKE\n <\/td>\n\n \ud328\ud134 \uac80\uc0c9\n <\/td>\n<\/tr>\n
\n IN\n <\/td>\n\n \uceec\ub7fc\uc758 \uc5ec\ub7ec \uac00\ub2a5\ud55c \uac12\ub4e4\uc744 \uc9c0\uc815\n <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n

\n
\n \uc870\uac74 \ud45c\ud604
\n <\/b>\n<\/p>\n

\n SQL\uc740 case\/when\/then\/else\/end \ud45c\ud604\uc744 \uac00\uc9c0\uace0 \uc788\uc73c\uba70, \uc774\uac83\uc740 SQL-92\uc5d0\uc11c \ub3c4\uc785\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc77c\ubc18\uc801\uc778 \ud615\uc2dd\uc5d0\uc11c, \uc774\uac83\uc740 SQL \ud45c\uc900\uc5d0\uc11c “searched case”\ub77c\uace0 \ubd88\ub9ac\uba70, \ub2e4\ub978 \ud504\ub85c\uadf8\ub7a8 \uc5b8\uc5b4\uc5d0\uc11c ‘else if’\uc640 \uac19\uc740 \uc5ed\ud560\uc744 \uc218\ud589\ud569\ub2c8\ub2e4.\n <\/p>\n

\n ‘WHEN’ \uc870\uac74\uc740 \uc18c\uc2a4\uc5d0\uc11c \ub4f1\uc7a5\ud558\ub294 \uc21c\uc11c\uc5d0\uc11c \uc2dc\ud5d8\ub429\ub2c8\ub2e4. \uc544\ubb34\ub7f0 ‘ELSE’ \ud45c\ud604\uc2dd\uc774 \uc9c0\uc815\ub418\uc9c0 \uc54a\uc73c\uba74, ‘ELSE NULL’\uc744 \uae30\ubcf8\uac12\uc73c\ub85c \ud558\uac8c \ub429\ub2c8\ub2e4. switch statement\ub97c \ubbf8\ub7ec\ub9c1 \ud558\ub294 \uc57d\uc5b4 \uad6c\ubb38\ub3c4 \uc874\uc7ac\ud569\ub2c8\ub2e4. \uc774\uac83\uc740 SQL \ud45c\uc900\uc5d0\uc11c “simple case”\ub77c\uace0 \ubd88\ub9bd\ub2c8\ub2e4.\n <\/p>\n

\n \ub9c8\uc9c0\ub9c9 \uac12\uc740 ‘default’\uc785\ub2c8\ub2e4. \uc544\ubb34\uac83\ub3c4 \uc9c0\uc815\ub418\uc9c0 \uc54a\uc73c\uba74, ‘NULL’\uc774 \uae30\ubcf8\uac12\uc774 \ub429\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \ud45c\uc900 “simple case”\uc640\ub294 \ub2ec\ub9ac \uc624\ub77c\ud074\uc758 ‘DECODE’\ub294 2\uac1c\uc758 NULL\uc744 \uc11c\ub85c \ub3d9\uc77c\ud55c \uac83\uc73c\ub85c \uac04\uc8fc\ud569\ub2c8\ub2e4.\n <\/p>\n

\n

\n

\n
\n SQL \uc790\ub8cc\ud615
\n <\/b>\n<\/p>\n

\n SQL \ud14c\uc774\ube14\uc5d0\uc11c \uac01 \uceec\ub7fc\uc740 \uceec\ub7fc\uc774 \ud3ec\ud568\ud558\ub294 \uc790\ub8cc\ud615(Data Type)\uc744 \uc120\uc5b8\ud569\ub2c8\ub2e4. ANSI SQL\uc740 \uc544\ub798\uc640 \uac19\uc740 \ub370\uc774\ud130\ud615\uc744 \ud3ec\ud568\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4.\n <\/p>\n

\n

\n
\n \ubb38\uc790\uc5f4
\n <\/b>\n<\/p>\n

\n CHARACTER(n) \ub610\ub294 CHAR(n) : \uace0\uc815\ud3ed n-\ubb38\uc790\uc5f4, (\ud544\uc694\ud55c \ub9cc\ud07c \uacf5\ubc31\uc73c\ub85c \ucc44\uc6cc\uc9d1\ub2c8\ub2e4.)\n <\/p>\n

\n CHARACTER VARYING(n) \ub610\ub294 VARCHAR(n) : \uac00\ubcc0\ud3ed \ubb38\uc790\uc5f4 (n \ubb38\uc790\uc758 \ucd5c\ub300 \ud06c\uae30\ub97c \uac00\uc9c4)\n <\/p>\n

\n NATIONAL CHARACTER(n) \ub610\ub294 NCHAR(n) : \uad6d\uc81c \ubb38\uc790\uc14b\uc744 \uc9c0\uc6d0\ud558\ub294 \uace0\uc815\ud3ed \ubb38\uc790\uc5f4\n <\/p>\n

\n NATIONAL CHARACTER VARYING(n) \ub610\ub294 NVARCHAR(n) : \uac00\ubcc0\ud3ed NCHAR \ubb38\uc790\uc5f4\n <\/p>\n

\n

\n
\n \ube44\ud2b8\uc5f4
\n <\/b>\n<\/p>\n

\n BIT(n) : n \ube44\ud2b8\uc758 \ubc30\uc5f4\n <\/p>\n

\n BIT VARYING(n) : n \ube44\ud2b8\uae4c\uc9c0\uc758 \ubc30\uc5f4\n <\/p>\n

\n

\n
\n \uc218
\n <\/b>\n<\/p>\n

\n INTEGER\uc640 SMALLINT\n <\/p>\n

\n FLOAT, REAL\uacfc DOUBLE PRECISION\n <\/p>\n

\n NUMERIC(precision, scale) \ub610\ub294 DECIMAL(precision, scale)\n <\/p>\n

\n \uc608\ub97c \ub4e4\uc5b4, \uc22b\uc790 123.45\ub294 5\ub77c\ub294 precision(\uc815\ubc00\ub3c4, \uc790\ub9ac\uac12)\uacfc 2\ub77c\ub294 scale(\uc18c\uc218\uc810 \uc774\ud558 \uc790\ub9bf\uc218)\uc744 \ud3ec\ud568\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. precision\uc740 \ud2b9\uc815 \uc9c4\ubc95(\uc774\uc9c4\ubc95 \ub610\ub294 \uc2ed\uc9c4\ubc95)\uc5d0\uc11c \uc911\uc694\ud55c 10 \uc790\ub9bf\uc218\ub97c \uacb0\uc815\ud558\ub294 \uc591\uc758 \uc815\uc218 \uac12\uc785\ub2c8\ub2e4. scale\uc740 \uc74c\uc774 \uc544\ub2cc \uc815\uc218\uc774\ub2e4. 0\uc758 scale\uc740 \uadf8 \uc218\uac00 \uc815\uc218\uc784\uc744 \uc9c0\uc2dc\ud558\ub294 \uc22b\uc790\uc785\ub2c8\ub2e4. S \uc790\ub9bf\uc218\ub97c \uac00\uc9c4 10\uc9c4\ubc95\uc5d0\uc11c, \uc815\ud655\ud55c \uc22b\uc790 \uac12\uc740 10S\ub85c \ub098\ub208 \uc911\uc694\ud55c 10\uc9c4\ubc95 \uc815\uc218 \uac12\uc785\ub2c8\ub2e4. SQL\uc740 \uc22b\uc790, \ub0a0\uc9dc\ub97c \ubc18\uc62c\ub9bc\ud574\uc8fc\ub294 TRUNC (\uc778\ud3ec\ubbf9\uc2a4, DB2, PostgreSQL, \uc624\ub77c\ud074 \uadf8\ub9ac\uace0 MySQL\uc5d0\uc11c) \ub610\ub294 ROUND (\uc778\ud3ec\ubbf9\uc2a4, SQLite, Sybase, Oracle, PostgreSQL and Microsoft SQL Server) \ud568\uc218\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4.\n <\/p>\n

\n

\n
\n \ub0a0\uc9dc\uc640 \uc2dc\uac04
\n <\/b>\n<\/p>\n

\n DATE : \ub0a0\uc9dc \uac12 (\uc608, 2011-05-03)\n <\/p>\n

\n TIME : \uc2dc\uac04 \uac12 (\uc608, 15:51:36). \uc2dc\uac04 \uac12\uc740 \ubcf4\ud1b5 tick (100 nanoseconds)\uc785\ub2c8\ub2e4.\n <\/p>\n

\n TIME WITH TIME ZONE or TIMETZ : TIME\uacfc \uac19\uc9c0\ub9cc, \ud574\ub2f9 \uc9c0\uc5ed\uc758 \uc2dc\uac04\ub300 \uc815\ubcf4\ub97c \ud3ec\ud568\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4.\n <\/p>\n

\n TIMESTAMP : \uc774\uac83\uc740 DATE\uc640 TIME\uc774 \ud558\ub098\uc758 \ubcc0\uc218\ub85c \uacb0\ud569\ub41c \uac83\uc785\ub2c8\ub2e4. (\uc608, 2011-05-03 15:51:36).\n <\/p>\n

\n TIMESTAMP WITH TIME ZONE or TIMESTAMPTZ : TIMESTAMP\uc640 \ub3d9\uc77c\ud558\uc9c0\ub9cc, \ud574\ub2f9 \uc9c0\uc5ed\uc758 \uc2dc\uac04\ub300\uc5d0 \ub300\ud55c \uc0c1\uc138 \uc815\ubcf4\ub97c \ud3ec\ud568\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4.\n <\/p>\n

\n SQL\uc740 \ub0a0\uc9dc \/ \uc2dc\uac04 \ubcc0\uc218\ub97c \uc0dd\uc131\ud558\ub294 \uc5ec\ub7ec \uac1c\uc758 \ud568\uc218\ub97c date \/ time \uc5f4 (TO_DATE, TO_TIME, TO_TIMESTAMP)\ub85c\ubd80\ud130 \uc81c\uacf5\ud569\ub2c8\ub2e4. \ub610\ud55c \uadf8\ub7ec\ud55c \uac01\uac01\uc758 \ubcc0\uc218 \ud56d\ubaa9 (\uc608\ub97c \ub4e4\uba74, \ucd08)\uc744 \ud1b5\ud574 \ucd94\ucd9c\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. \ud604\uc7ac \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84 \uc2dc\uc2a4\ud15c\uc758 \ub0a0\uc9dc \/ \uc2dc\uac04\uc740 NOW\uc640 \uac19\uc740 \ud568\uc218\ub97c \ud1b5\ud574 \ud638\ucd9c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\n <\/p>\n

\n

\n

\n
\n \ub3d9\uc801 SQL
\n <\/b>
\n : \ub3d9\uc801 SQL\uc740 \uc77c\ubc18\uc801\uc73c\ub85c SQL\ubb38\uc744 RDBMS\uc5d0 \ubcf4\ub0bc \ub54c\ub9c8\ub2e4 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5d4\uc9c4\uc5d0\uc11c \uc2e4\ud589 \uac00\ub2a5\ud55c \ub0b4\ubd80 \uc911\uac04 \ucf54\ub4dc\ub85c \ubc88\uc5ed\ud558\ub294 \uc791\uc5c5\uc744 \ubbf8\ub9ac \uc218\ud589\ud558\uc5ec \ubcc0\ud658\ub41c SQL \ucf54\ub4dc\ub97c \uc7ac\uc0ac\uc6a9\ud558\uc5ec, SQL \ubd84\uc11d \uc624\ubc84\ud5e4\ub4dc\ub97c \uc904\uc774\uace0, SQL \ubb38\uc744 \uc18c\uc2a4 \ucf54\ub4dc\ub85c \uace0\uc815\ud558\uc9c0 \uc54a\uace0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc561\uc138\uc2a4 \ud560 \ub54c\ub9c8\ub2e4 \uad6c\ubb38\uc744 \ub2e4\uc2dc \ud560 \uacbd\uc6b0 \uc720\uc6a9\ud569\ub2c8\ub2e4. \ub370\uc774\ud130 \uc870\uc791 \uc5b8\uc5b4(DML)\ub3c4 \ubb3c\ub860 \uc218\ud589\ud560 \uc218 \uc788\uc9c0\ub9cc, \ub370\uc774\ud130 \uc815\uc758 \uc5b8\uc5b4 (DDL)\uc640 \uac19\uc774 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc81c\ud488\uc758 \uae30\ub2a5 \uc5c5\ub370\uc774\ud2b8\uc5d0 \uc758\ud574 \uc0c8\ub85c\uc6b4 \uba85\ub839\uc774 \ucd94\uac00\ub418\ub294 \uac83\uc740 \uc804\ucc98\ub9ac \ud574\ub2f9 \uc791\uc5c5\uc774 \ubd80\ub2f4\uc774 \ub418\uae30 \ub54c\ubb38\uc5d0, \ub300\ubd80\ubd84\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc81c\ud488\uc5d0\uc11c\ub294 DDL \ubb38\uc740 \ub3d9\uc801 SQL\uc5d0\uc11c \uc2e4\ud589\ud558\ub294 \uac83\uc774 \uc77c\ubc18\uc801\uc785\ub2c8\ub2e4.\n <\/p>\n

\n PREPARE (\ubb38\uc790\uc5f4\ub85c \uc900 SQL \ubb38\uc744 \ud574\uc11d, \ubc88\uc5ed)\n <\/p>\n

\n EXECUTE (PREPARE\ub85c \ubc88\uc5ed\ud55c SQL \ubb38\uc744 \uc2e4\ud589)\n <\/p>\n

\n

\n
\n \uc784\ubca0\ub514\ub4dc SQL
\n <\/b>
\n : \uc784\ubca0\ub514\ub4dc SQL(\ub610\ub294 \ub0b4\uc7a5 SQL)\uc740 \uc6d0\ub798 \ucee4\uc11c\uac00 \ud3ec\ud568\ub41c SQL\uc5d0\uc11c \ud638\uc2a4\ud2b8 \uc5b8\uc5b4\uc5d0\uc11c \uacb0\uacfc \uc9d1\ud569\uc744 \uc5bb\uae30 \uc704\ud574 \ub354 \ud3b8\ub9ac\ud55c \ubc29\ubc95\uc73c\ub85c \uace0\uc548\ub41c \uac83\uc785\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \ud1b5\uc2e0\ud558\uae30 \uc704\ud55c \uc790\uc6d0 \ud560\ub2f9 \ud655\ubcf4\uc640 \uac1c\ubc29\ud55c \uc904\uc5d0 \ud638\uc2a4\ud2b8 \uc5b8\uc5b4\uc758 \ubc18\ubcf5\uc73c\ub85c \uac00\uc838\uc624\uae30 \uc704\ud55c \uba85\ub839(FETCH) \ub4f1\uc774 \uc788\uc2b5\ub2c8\ub2e4.\n <\/p>\n

\n ALLOCATE (DEALLOCATE) DESCRIPTOR (\ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubc0f \ud638\uc2a4\ud2b8 \uc5b8\uc5b4 \uac04 \ud1b5\uc2e0 \uc601\uc5ed\uc758 \ud655\ubcf4\uc640 \uac1c\ubc29)\n <\/p>\n

\n WHENEVER (\uc624\ub958 \ubc1c\uc0dd \uc2dc\uc758 \ub3d9\uc791\uc744 \uc815\uc758)\n <\/p>\n

\n SQLSTATE (SQL \ubb38 \uc2e4\ud589 \ud6c4 \uc0c1\ud0dc\uac00 \uc800\uc7a5\ub418\ub294 \uc601\uc5ed)\n <\/p>\n

\n

\n
\n 3 \uac12 \ub17c\ub9ac
\n <\/b>
\n : SQL\uc5d0\uc11c \uc0ac\uc6a9\ub418\ub294 \ub17c\ub9ac \uac12\uc740 \ucef4\ud4e8\ud130 \uc138\uacc4\uc5d0\uc11c \uac00\uc7a5 \ub110\ub9ac \uc774\uc6a9\ub418\ub294 ‘2 \uac12 \ub17c\ub9ac(TRUE, FALSE)’ \ub300\uc2e0 ‘3 \uac12 \ub17c\ub9ac(TRUE, FALSE, UNKNOWN)’\uc774 \uc788\uc2b5\ub2c8\ub2e4.\n <\/p>\n

\n

\n

\n
\n SQL \uc5b8\uc5b4 \uc694\uc18c
\n <\/b>\n<\/p>\n

\n \uc544\ub798\ub294 \ub9ce\uc740 SQL\ubb38\uc5d0 \uacf5\ud1b5\ub418\ub294 SQL \ubc0f \uc5b8\uc5b4 \uc694\uc18c\uc758 \uae30\ubcf8 \uad6c\ubb38\uc744 \uc815\uc758\ud569\ub2c8\ub2e4.\n <\/p>\n

\n

\n
\n [\ubb38\uc790] :
\n <\/b>
\n SQL \uc5b8\uc5b4\uc5d0\uc11c \ud0a4\uc6cc\ub4dc\uc640 \uc870\uc791\uc758 \uae30\ubcf8 \uae30\ud638\ub294 IBM \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc81c\ud488\uc774 \uc9c0\uc6d0\ud558\ub294 \ubaa8\ub4e0 \ubb38\uc790 \uc138\ud2b8\uc758 \uc77c\ubd80\uc778 \ub2e8\uc77c \ubc14\uc774\ud2b8 \ubb38\uc790\uc785\ub2c8\ub2e4.\n <\/p>\n

\n
\n [\ud1a0\ud070] :
\n <\/b>
\n \uc5b8\uc5b4\uc758 \uae30\ubcf8 \uad6c\ubb38 \ub2e8\uc704\ub97c \ud1a0\ud070\uc774\ub77c\uace0 \ubd80\ub985\ub2c8\ub2e4. \ud1a0\ud070\uc740 \uacf5\ubc31, \uc81c\uc5b4 \ubb38\uc790 \ubc0f \uc2a4\ud2b8\ub9c1 \uc0c1\uc218 \ub0b4\uc758 \ubb38\uc790\ub098 \ubd84\ub9ac ID\ub97c \uc81c\uc678\ud558\uace0 \ud558\ub098 \uc774\uc0c1\uc758 \ubb38\uc790\ub85c \uad6c\uc131\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. (\uc774\ub7ec\ud55c \uc6a9\uc5b4\ub294 \ub098\uc911\uc5d0 \uc815\uc758\ub429\ub2c8\ub2e4.)\n <\/p>\n

\n
\n [ID] :
\n <\/b>
\n ID\ub294 \uc774\ub984\uc744 \ud615\uc131\ud558\ub294 \ub370 \uc0ac\uc6a9\ub418\ub294 \ud1a0\ud070\uc785\ub2c8\ub2e4. SQL\ubb38\uc758 ID\ub294 SQL ID, \uc2dc\uc2a4\ud15c ID \ub610\ub294 \ud638\uc2a4\ud2b8 ID\uc785\ub2c8\ub2e4.\n <\/p>\n

\n
\n [\uc774\ub984 \uc9c0\uc815 \uaddc\uce59] :
\n <\/b>
\n \uc774\ub984 \ud615\uc131 \uaddc\uce59\uc740 \uc774\ub984\uacfc \uc774\ub984 \uc9c0\uc815 \uc635\uc158\uc774 \uc9c0\uc815\ud558\ub294 \uc624\ube0c\uc81d\ud2b8\uc758 \uc720\ud615\uc5d0 \ub530\ub77c \ub2e4\ub985\ub2c8\ub2e4(*SQL \ub610\ub294 *SYS). \uc774\ub984 \uc9c0\uc815 \uc635\uc158\uc740 CRTSQLxxx, RUNSQLSTM \ubc0f STRSQL \uba85\ub839\uc5d0 \uc9c0\uc815\ub429\ub2c8\ub2e4. SET OPTION \uba85\ub839\ubb38\uc740 \uc0bd\uc785\ub41c SQL\uc744 \ud3ec\ud568\ud558\ub294 \ud504\ub85c\uadf8\ub7a8\uc758 \uc18c\uc2a4 \ub0b4\uc5d0 \uc774\ub984 \uc9c0\uc815 \uc635\uc158\uc744 \uc9c0\uc815\ud558\ub294 \ub370 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uad6c\ubb38 \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc740 \ub2e4\ub978 \uc720\ud615\uc758 \uc774\ub984\uc5d0 \ub300\ud574 \ub2e4\ub978 \uc6a9\uc5b4\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.\n <\/p>\n

\n
\n [\ubcc4\uba85] :
\n <\/b>
\n \ubcc4\uba85\uc740 \ud14c\uc774\ube14\uc758 \ub300\uccb4 \uc774\ub984, \ud14c\uc774\ube14\uc758 \ud30c\ud2f0\uc158, \ubcf4\uae30 \ub610\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud30c\uc77c\uc758 \uba64\ubc84\ub85c \uac04\uc8fc\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. SQL\ubb38\uc758 \ud14c\uc774\ube14 \ub610\ub294 \ubcf4\uae30\ub294 \ud574\ub2f9 \uc774\ub984 \ub610\ub294 \ubcc4\uba85\uc5d0 \uc758\ud574 \ucc38\uc870\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubcc4\uba85\uc740 \ub3d9\uc77c \ub610\ub294 \uc6d0\uaca9 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub0b4\uc5d0\uc11c \ud14c\uc774\ube14, \ud14c\uc774\ube14\uc758 \ud30c\ud2f0\uc158, \ubcf4\uae30 \ub610\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud30c\uc77c \uba64\ubc84\ub97c \uac00\ub9ac\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4.\n <\/p>\n

\n
\n [\uad8c\ud55c \ubd80\uc5ec ID \ubc0f \uad8c\ud55c \ubd80\uc5ec \uc774\ub984] :
\n <\/b>
\n \uad8c\ud55c \ubd80\uc5ec ID\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \ud504\ub85c\uadf8\ub7a8\uacfc \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ud504\ub85c\uc138\uc2a4 \ub610\ub294 \ud504\ub85c\uadf8\ub7a8 \uc900\ube44 \ud504\ub85c\uc138\uc2a4 \uac04\uc758 \uc5f0\uacb0\uc744 \uc124\uc815\ud560 \ub54c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c \ud655\ubcf4\ud558\ub294 \uc2a4\ud2b8\ub9c1\uc73c\ub85c\uc11c, \uad8c\ud55c \uc138\ud2b8\ub97c \uc9c0\uc815\ud569\ub2c8\ub2e4. \ub610\ud55c \uc0ac\uc6a9\uc790\ub098 \uc0ac\uc6a9\uc790 \uadf8\ub8f9\uc744 \uc9c0\uc815\ud560 \uc218\ub3c4 \uc788\uc9c0\ub9cc, \uc774 \ud2b9\uc131\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c \uc81c\uc5b4\ud558\uc9c0\ub294 \uc54a\uc2b5\ub2c8\ub2e4.\n <\/p>\n

\n
\n [\ud504\ub85c\uc2dc\uc800 \ud574\uacb0] :
\n <\/b>
\n \ud504\ub85c\uc2dc\uc800 \ud638\ucd9c \uc2dc DB2\ub294 \ub3d9\uc77c\ud55c \uc774\ub984\uc758 \ud504\ub85c\uc2dc\uc800 \uc911 \uc2e4\ud589 \uac00\ub2a5\ud55c \ud504\ub85c\uc2dc\uc800\ub97c \uacb0\uc815\ud574\uc57c \ud569\ub2c8\ub2e4.\n <\/p>\n

\n
\n [\ub370\uc774\ud130 \uc720\ud615] :
\n <\/b>
\n SQL\uc5d0\uc11c \uc870\uc791\ud560 \uc218 \uc788\ub294 \uac00\uc7a5 \uc791\uc740 \ub370\uc774\ud130 \ub2e8\uc704\ub294 \uac12\uc785\ub2c8\ub2e4.\n <\/p>\n

\n
\n [\ub370\uc774\ud130 \uc720\ud615 \uc2b9\uaca9] :
\n <\/b>
\n \ub370\uc774\ud130 \uc720\ud615\uc740 \uad00\ub828 \ub370\uc774\ud130 \uc720\ud615 \uadf8\ub8f9\uc73c\ub85c \ubd84\ub958\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub7f0 \uadf8\ub8f9 \ub0b4\uc5d0\uc11c \uc784\uc758\uc758 \ub370\uc774\ud130 \uc720\ud615\uc774 \ub2e4\ub978 \ub370\uc774\ud130 \uc720\ud615 \uc55e\uc5d0 \uace0\ub824\ub418\ub294 \uc6b0\uc120\uc21c\uc704\uc758 \uc21c\uc11c\uac00 \uc874\uc7ac\ud569\ub2c8\ub2e4. \uc774 \uc6b0\uc120\uc21c\uc704\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac\uc790\ub294 \uc784\uc758\uc758 \ub370\uc774\ud130 \uc720\ud615\uc744 \uc6b0\uc120\uc21c\uc704 \uc21c\uc11c\uc5d0\uc11c \ub098\uc911\uc5d0 \ud45c\uc2dc\ub418\ub294 \ub2e4\ub978 \ub370\uc774\ud130 \uc720\ud615\uc73c\ub85c \uc2b9\uaca9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ub370\uc774\ud130 \uc720\ud615 CHAR\uc774 VARCHAR\ub85c \uc2b9\uaca9\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. INTEGER\ub294 DOUBLE PRECISION\uc73c\ub85c \uc2b9\uaca9\ud560 \uc218 \uc788\uc9c0\ub9cc CLOB\ub294 VARCHAR\ub85c \uc2b9\uaca9\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.\n <\/p>\n

\n
\n [\ub370\uc774\ud130 \uc720\ud615 \uc0ac\uc774\uc758 \uce90\uc2a4\ud305] :
\n <\/b>
\n \uc81c\uacf5\ub41c \ub370\uc774\ud130 \uc720\ud615\uc744 \uac00\uc9c0\ub294 \uac12\uc774 \ub2e4\ub978 \ub370\uc774\ud130 \uc720\ud615 \ub610\ub294 \ub2e4\ub978 \uae38\uc774, \uc815\ubc00\ub3c4\ub098 \uc2a4\ucf00\uc77c\uc744 \uac00\uc9c0\ub294 \ub3d9\uc77c\ud55c \ub370\uc774\ud130 \uc720\ud615\uc73c\ub85c \uce90\uc2a4\ud2b8(\ubcc0\uacbd)\ub418\uc5b4\uc57c \ud558\ub294 \ub9ce\uc740 \uacbd\uc6b0\uac00 \uc788\uc2b5\ub2c8\ub2e4.\n <\/p>\n

\n
\n [\uc9c0\uc815 \ubc0f \ube44\uad50] :
\n <\/b>
\n SQL\uc758 \uae30\ubcf8 \uc870\uc791\uc740 \uc9c0\uc815 \ubc0f \ube44\uad50\uc785\ub2c8\ub2e4. \uc9c0\uc815 \uc870\uc791\uc740 CALL, INSERT, UPDATE, FETCH, SELECT, SET \ubcc0\uc218 \ubc0f VALUES INTO \uba85\ub839\ubb38\uc758 \uc2e4\ud589 \uc911\uc5d0 \uc218\ud589\ub429\ub2c8\ub2e4. \ube44\uad50 \uc870\uc791\uc740 MAX, MIN, DISTINCT, GROUP BY \ubc0f ORDER BY \ub4f1\uacfc \uac19\uc740 \uc220\ubd80 \ubc0f \uae30\ud0c0 \uc5b8\uc5b4 \uc694\uc18c\ub97c \ud3ec\ud568\ud558\ub294 \uba85\ub839\ubb38\uc758 \uc2e4\ud589 \uc911\uc5d0 \uc218\ud589\ub429\ub2c8\ub2e4.\n <\/p>\n

\n
\n [\uacb0\uacfc \ub370\uc774\ud130 \uc720\ud615\uc758 \uaddc\uce59] :
\n <\/b>
\n \uacb0\uacfc\uc758 \ub370\uc774\ud130 \uc720\ud615\uc740 \uc5f0\uc0b0\uc5d0\uc11c \ud53c\uc5f0\uc0b0\uc790\uc5d0 \uc801\uc6a9\ub418\ub294 \uaddc\uce59\uc73c\ub85c \ud310\ubcc4\ub429\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \ud574\ub2f9 \uaddc\uce59\uc5d0 \ub300\ud574 \uc124\uba85\ud569\ub2c8\ub2e4.\n <\/p>\n

\n
\n [\uc2a4\ud2b8\ub9c1 \uacb0\ud569 \uc5f0\uc0b0\uc744 \uc704\ud55c \ubcc0\ud658 \uaddc\uce59] :
\n <\/b>
\n \uc2a4\ud2b8\ub9c1\uc744 \uacb0\ud569\ud558\ub294 \uc5f0\uc0b0\uc740 \uc5f0\uacb0, UNION, UNION ALL, EXCEPT \ubc0f INTERSECT\uc785\ub2c8\ub2e4. (\uc774\ub4e4 \uaddc\uce59\uc740 MAX, MIN, VALUE, COALESCE, IFNULL \ubc0f CONCAT \uc2a4\uce7c\ub77c \ud568\uc218\uc640 CASE \ud45c\ud604\uc2dd\uc5d0\ub3c4 \uc801\uc6a9\ub429\ub2c8\ub2e4.) \uac01\uac01\uc758 \uacbd\uc6b0\uc5d0 \uacb0\uacfc\uc758 CCSID\ub294 \ubc14\uc778\ub4dc \uc2dc \ud310\ubcc4\ub418\uace0 \uc5f0\uc0b0\uc758 \uc2e4\ud589\uc5d0\ub294 \uc2a4\ud2b8\ub9c1\uc744 CCSID\ub85c \uc2dd\ubcc4\ub418\ub294 \ucf54\ub4dc\ud654 \ubb38\uc790 \uc138\ud2b8\ub85c \ubcc0\ud658\ud558\ub294 \uac83\uc774 \ud3ec\ud568\ub429\ub2c8\ub2e4.\n <\/p>\n

\n
\n [\uc0c1\uc218] :
\n <\/b>
\n \uc0c1\uc218(\ub9ac\ud130\ub7f4\uc774\ub77c\uace0\ub3c4 \ubd88\ub9bc)\ub294 \uac12\uc744 \uc9c0\uc815\ud569\ub2c8\ub2e4. \uc0c1\uc218\ub294 \uc2a4\ud2b8\ub9c1 \uc0c1\uc218 \ub610\ub294 \uc22b\uc790 \uc0c1\uc218\ub85c \ubd84\ub958\ub429\ub2c8\ub2e4. \uc2a4\ud2b8\ub9c1 \uc0c1\uc218\ub294 \ucd94\uac00\ub85c \ubb38\uc790 \ub610\ub294 \uadf8\ub798\ud53d\uc73c\ub85c \ubd84\ub958\ub429\ub2c8\ub2e4. \uc22b\uc790 \uc0c1\uc218\ub294 \ucd94\uac00\ub85c \uc815\uc218, \ubd80\ub3d9 \uc18c\uc218\uc810 \ub610\ub294 \uc2ed\uc9c4\uc73c\ub85c \ubd84\ub958\ub429\ub2c8\ub2e4.\n <\/p>\n

\n
\n [\ud2b9\uc218 \ub808\uc9c0\uc2a4\ud130] :
\n <\/b>
\n \ud2b9\uc218 \ub808\uc9c0\uc2a4\ud130\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac\uc790\uc5d0 \uc758\ud574 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ud504\ub85c\uc138\uc2a4\uc5d0 \ub300\ud574 \uc815\uc758\ub418\ub294 \uc2a4\ud1a0\ub9ac\uc9c0 \uc601\uc5ed\uc774\uace0, SQL\ubb38\uc5d0 \ucc38\uc870\ub420 \uc218 \uc788\ub294 \uc815\ubcf4\ub97c \uc800\uc7a5\ud558\uae30 \uc704\ud574 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. \ud2b9\uc218 \ub808\uc9c0\uc2a4\ud130\uc5d0 \ub300\ud55c \ucc38\uc870\ub294 \ud604\uc7ac \uc11c\ubc84\uac00 \uc81c\uacf5\ud55c \uac12\uc5d0 \ub300\ud55c \ucc38\uc870\uc785\ub2c8\ub2e4. \uac12\uc774 \uc2a4\ud2b8\ub9c1\uc778 \uacbd\uc6b0, \ud574\ub2f9 CCSID\ub294 \ud604\uc7ac \uc11c\ubc84\uc758 \ub514\ud3f4\ud2b8 CCSID\uc785\ub2c8\ub2e4.\n <\/p>\n

\n
\n [\uc5f4 \uc774\ub984] :
\n <\/b>
\n \uc5f4 \uc774\ub984\uc758 \uc758\ubbf8\ub294 \ucf58\ud14d\uc2a4\ud2b8\uc5d0 \ub530\ub77c \ub2e4\ub985\ub2c8\ub2e4.\n <\/p>\n

\n
\n [\ubcc0\uc218] :
\n <\/b>
\n SQL\ubb38\uc758 \ubcc0\uc218\ub294 SQL\ubb38\uc774 \uc2e4\ud589\ub420 \ub54c \ubcc0\uacbd\ud560 \uc218 \uc788\ub294 \uac12\uc744 \uc9c0\uc815\ud569\ub2c8\ub2e4.\n <\/p>\n

\n
\n [\ud568\uc218] :
\n <\/b>
\n \ud568\uc218\ub294 \uad04\ud638 \uc548\uc5d0 \ub4e4\uc5b4 \uc788\ub294 \ud558\ub098 \uc774\uc0c1\uc758 \ud53c\uc5f0\uc0b0\uc790\uac00 \ub4a4\uc5d0 \ubd99\ub294 \ud568\uc218 \uc774\ub984\uc774 \ud45c\uc2dc\ud558\ub294 \uc870\uc791\uc785\ub2c8\ub2e4. \ud568\uc218\ub294 \uc785\ub825 \uac12 \uc138\ud2b8\uc640 \uacb0\uacfc \uac12 \uc138\ud2b8 \uac04\uc758 \uad00\uacc4\ub97c \ub098\ud0c0\ub0c5\ub2c8\ub2e4. \ud568\uc218\uc5d0 \ub300\ud55c \uc785\ub825 \uac12\uc744 \uc778\uc218\ub77c\uace0 \ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ud568\uc218\uc5d0 \ub0a0\uc9dc \ubc0f \uc2dc\uac04 \ub370\uc774\ud130 \uc720\ud615\uc744 \uac16\ub294 \ub450 \uac1c\uc758 \uc785\ub825 \uc778\uc218\ub97c \uc804\ub2ec\ud558\uba74 \uc2dc\uac04\uc18c\uc778 \ub370\uc774\ud130 \uc720\ud615\uc73c\ub85c \ub41c \uac12\uc774 \uacb0\uacfc\ub85c \ub9ac\ud134\ub429\ub2c8\ub2e4.\n <\/p>\n

\n
\n [\ud45c\ud604\uc2dd] :
\n <\/b>
\n \ud45c\ud604\uc2dd\uc740 \uac12\uc744 \uc9c0\uc815\ud569\ub2c8\ub2e4.\n <\/p>\n

\n
\n [\uc220\ubd80] :
\n <\/b>
\n \uc220\ubd80\ub294 \uc8fc\uc5b4\uc9c4 \uac12, \ud589 \ub610\ub294 \uadf8\ub8f9\uc5d0 \ub300\ud574 \ucc38, \uac70\uc9d3 \ub610\ub294 \uc54c \uc218 \uc5c6\uc74c \uc870\uac74\uc744 \uc9c0\uc815\ud569\ub2c8\ub2e4.\n <\/p>\n

\n
\n [\uac80\uc0c9 \uc870\uac74] :
\n <\/b>
\n \uac80\uc0c9 \uc870\uac74\uc740 \ud574\ub2f9 \ud589 \ub610\ub294 \uadf8\ub8f9\uc5d0 \ub300\ud55c true, false \ub610\ub294 \uc54c \uc218 \uc5c6\uc74c \uc870\uac74\uc744 \uc9c0\uc815\ud569\ub2c8\ub2e4.\n <\/p>\n

\n<\/div>\n","protected":false},"excerpt":{"rendered":"

SQL \ub85c\uace0(SQL LOGO) SQL(Structured Query Language)\uc774\ub780? SQL\uc740 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc870\uc791\uacfc \uad00\ub9ac\uc5d0 \uc0ac\uc6a9\ub418\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc9c8\uc758\uc6a9 \uc5b8\uc5b4\uc785\ub2c8\ub2e4. 1970\ub144\ub300 IBM \ud68c\uc0ac\uc5d0 \uc758\ud558\uc5ec \uac1c\ubc1c\ub418\uc5c8\uace0, IBM\uc758 \uad00\uacc4\ud615 DBMS\uc5d0\uc11c \ucc98\uc74c \uc0ac\uc6a9\ub410\uc2b5\ub2c8\ub2e4. \uc774\ud6c4 1986\ub144 \ubbf8\uad6d\ud45c\uc900\ud611\ud68c(ANSI)\uac00 SQL \ud45c\uc900\uc744 \ucc44\ud0dd\ud568\uc5d0 \ub530\ub77c \ud604\uc7ac\ub294 IBM\uc758 DB2, \ub9c8\uc774\ud06c\ub85c\uc18c\ud504\ud2b8\uc758 Access\uc640 SQL Server\ub97c \ube44\ub86f\ud558\uc5ec Oracle, Sybase, Informix \ub4f1\uc5d0\uc11c \uad6c\uc870\ud654 \uc9c8\uc758\uc5b4\ub85c \ub110\ub9ac \uc0ac\uc6a9\ub418\uace0 \uc788\uc2b5\ub2c8\ub2e4. SQL\uc740 \uc6d0\ud558\ub294 \ub370\uc774\ud130\uac00 \ubb34\uc5c7(What)\uc778\uc9c0\ub9cc \uae30\uc220\ud558\uace0, \uac80\uc0c9…<\/p>\n","protected":false},"author":1,"featured_media":392,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[17],"tags":[],"_links":{"self":[{"href":"https:\/\/the.2days.kr\/index.php?rest_route=\/wp\/v2\/posts\/393"}],"collection":[{"href":"https:\/\/the.2days.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/the.2days.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/the.2days.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/the.2days.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=393"}],"version-history":[{"count":1,"href":"https:\/\/the.2days.kr\/index.php?rest_route=\/wp\/v2\/posts\/393\/revisions"}],"predecessor-version":[{"id":394,"href":"https:\/\/the.2days.kr\/index.php?rest_route=\/wp\/v2\/posts\/393\/revisions\/394"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/the.2days.kr\/index.php?rest_route=\/wp\/v2\/media\/392"}],"wp:attachment":[{"href":"https:\/\/the.2days.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=393"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/the.2days.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=393"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/the.2days.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=393"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}