{"id":512,"date":"2015-02-25T11:10:36","date_gmt":"2015-02-25T20:10:36","guid":{"rendered":"\/blog\/?p=512"},"modified":"2023-09-21T09:38:40","modified_gmt":"2023-09-21T00:38:40","slug":"oracle-data-types","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=512","title":{"rendered":"Oracle Data Types"},"content":{"rendered":"\n<h3><ins><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">0. \ub370\uc774\ud130 \ud0c0\uc785 \ubc0f \uae38\uc774\uc758 \uc911\uc694\uc131<\/span><\/ins><\/h3><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n<\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uac01 \ub370\uc774\ud130 \ud0c0\uc785\uc758 \uace0\uc720\ud55c \ud2b9\uc131\uc774 \uc788\ub2e4 -&gt; \uceec\ub7fc \uc18d\uc131\uc5d0 \ub9de\ub294 \ub370\uc774\ud130 \ud0c0\uc785\uc744 \uc0ac\uc6a9\ud588\ub290\ub0d0 \uc5ec\ubd80\uc5d0 \ub530\ub77c\uc11c \ub9ce\uc740 \ucc28\uc774\uac00 \ubc1c\uc0dd<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc801\uc808\ud558\uc9c0 \ubabb\ud55c \ub370\uc774\ud130 \ud0c0\uc785 \uc120\uc815 -&gt; \uc218\ud589\uc18d\ub3c4 \uc800\ud558, \ubd88\ud544\uc694\ud55c \uc790\uc6d0\uc758 \ub0ad\ube44 \ucd08\ub798<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uac01 \ub370\uc774\ud130 \ud0c0\uc785\uc758 \ud2b9\uc131\uc5d0 \ub530\ub77c \uc815\ubcf4\ub97c \uac00\uc7a5 \ud6a8\uc728\uc801\uc73c\ub85c \ucc98\ub9ac\ud558\uae30 \uc704\ud55c \uc801\uc808\ud55c \ub370\uc774\ud130 \ud0c0\uc785\uc744 \uc120\uc815\ud574\uc57c \ud55c\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">CHAR, VARCHAR, NUMBER, DATE, LONG, RAW, LONG RAW, ROWID, LOB \ub4f1<br \/><br \/><\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n\n<\/span><h3><a name=\"\uc81c3\uc7a5\ub370\uc774\ud130\ud0c0\uc785\ubc0f\uae38\uc774\uc758\uacb0\uc815-1.\ub370\uc774\ud130\ud0c0\uc785\uc120\uc815\uc808\ucc28\"><\/a><ins><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">1. \ub370\uc774\ud130 \ud0c0\uc785 \uc120\uc815 \uc808\ucc28<\/span><\/ins><\/h3><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n<\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ubb3c\ub9ac\uc801 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4\uc758 \uac00\uc7a5 \ub9c8\uc9c0\ub9c9 \ub2e8\uacc4\uc5d0\uc11c \ub370\uc774\ud130 \ud0c0\uc785 \ubc0f \uae38\uc774\ub97c \uacb0\uc815<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ub370\uc774\ud130 \ud0c0\uc785 \uacb0\uc815 \ud6c4 \uae38\uc774 \uacb0\uc815<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n\n<\/span><h4><a name=\"\uc81c3\uc7a5\ub370\uc774\ud130\ud0c0\uc785\ubc0f\uae38\uc774\uc758\uacb0\uc815-1.1\ubb38\uc790\ud0c0\uc785vs.\uc22b\uc790\ud0c0\uc785\"><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">1.1 \ubb38\uc790\ud0c0\uc785 vs. \uc22b\uc790\ud0c0\uc785<\/span><\/h4><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n<\/span><ol><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc5f0\uc0b0\uc744 \ud558\uac8c \ub418\ub294 \uceec\ub7fc\uc778 \uacbd\uc6b0 : \uc22b\uc790\ud0c0\uc785<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ub2e4\ub978 \uacbd\uc6b0\ub294 \uc22b\uc790 \ub610\ub294 \ubb38\uc790\ub85c \ud560 \uc218 \uc788\uc74c<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ubb38\uc790\uc640 \uc22b\uc790\ub97c \uacb0\ud569\ud558\ub294 \uac83\uc740 \uc88b\uc9c0 \uc54a\uc74c\n <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc608) A0001 \uacfc \uac19\uc774 \ubb38\uc790\ucf54\ub4dc + \ub2e8\uc21c\uc99d\uac00 \uc77c\ub828\ubc88\ud638\n         <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ucc28\ub77c\ub9ac \ubb38\uc790\ucf54\ub4dc \ubd80\ubd84\uc744 \ubcc4\ub3c4 \uceec\ub7fc\uc73c\ub85c \ubd84\ub9ac\ud558\uace0 \uc77c\ub828\ubc88\ud638 \ubd80\ubd84\uc740 \uc22b\uc790\ud0c0\uc785\uc73c\ub85c \ucc98\ub9ac\ud558\ub294 \uac83\uc774 \ub0ab\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc608\uc678) \uac01 \uc790\ub9ac\uc218\ub9c8\ub2e4 \ud2b9\uc815\ud55c \uc758\ubbf8\uac00 \ubd80\uc5ec\ub41c \uacbd\uc6b0 : \uae38\uc774\uace0\uc815, \ubb38\uc790\ud0c0\uc785\uc73c\ub85c \uc9c0\uc815 -&gt; \ubcc0\ubcc4\ub825 \ud5a5\uc0c1, \uc0ac\uc6a9\uc0c1\uc758 \ud3b8\uc758<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n             <\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n     <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uae30\ud0c0 \uacbd\uc6b0\n     <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc22b\uc790\ub97c \uac00\uc9c0\ub294 \ud55c\uc790\ub9ac\ub85c \uc9c0\uc815\ub41c \uceec\ub7fc : \ubb38\uc790\ud0c0\uc785\uc73c\ub85c \uc9c0\uc815\n         <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc22b\uc790\ud0c0\uc785\uc73c\ub85c \ud558\ub294 \uacbd\uc6b0 \uc624\ud788\ub824 \uc800\uc7a5\ub418\ub294 \uae38\uc774\uac00 \ub298\uc5b4\ub09c\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ub2e4\ub978 \uceec\ub7fc\uacfc \ube44\uad50\ub420\ub54c \ub0b4\ubd80\uc801\uc778 \ubcc0\ud615 \ubc1c\uc0dd : \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uac8c \ub420 \uc218 \uc788\uc74c<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n            <\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n     <\/span><\/li><\/ol><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n\n<\/span><h4><a name=\"\uc81c3\uc7a5\ub370\uc774\ud130\ud0c0\uc785\ubc0f\uae38\uc774\uc758\uacb0\uc815-1.2\ubb38\uc790\ud0c0\uc785\"><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">1.2 \ubb38\uc790\ud0c0\uc785<\/span><\/h4><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n<\/span><ol><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc77c\ubc18\ubb38\uc790\ud0c0\uc785(CHAR, VARCHAR) vs. \ud2b9\uc218\ud615\ud0dc\ubb38\uc790\ud0c0\uc785(LONG, RAW, LONG RAW)<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc77c\ubc18\ubb38\uc790\ud0c0\uc785\uc778 \uacbd\uc6b0\n <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uace0\uc815\uae38\uc774(CHAR) vs. \uac00\ubcc0\uae38\uc774(VARCHAR)<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uceec\ub7fc\uae38\uc774 \uacb0\uc815 : \ud574\ub2ec \uceec\ub7fc\uc758 \ucd5c\ub300\uae38\uc774\ub97c \uc870\uc0ac<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ucd5c\ub300\uae38\uc774\uac00 4\ucc9c\ubc14\uc774\ud2b8\uac00 \ub118\ub294 \uacbd\uc6b0 : LONG \ud0c0\uc785 \uc0ac\uc6a9 vs. \uc5ec\ub7ec\uac1c\uc758 VARCHAR\ub85c \ubd84\ub9ac<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n  <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ubbf8\ub514\uc5b4(\uc74c\uc131, \uc601\uc0c1) \uc815\ubcf4\uc758 \ucc98\ub9ac\n        <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ud14c\uc774\ube14 \uceec\ub7fc\uc73c\ub85c \uc9c0\uc815 vs. \ub9e4\uccb4 \uc774\uc6a9<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n    <\/span><\/li><\/ol><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n\n<\/span><h4><a name=\"\uc81c3\uc7a5\ub370\uc774\ud130\ud0c0\uc785\ubc0f\uae38\uc774\uc758\uacb0\uc815-1.3\uc22b\uc790\ud0c0\uc785\"><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">1.3 \uc22b\uc790\ud0c0\uc785<\/span><\/h4><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n<\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uceec\ub7fc\uac12\uc774 \uc22b\uc790\ub77c\uace0 \ud574\uc11c \uaf2d \uc22b\uc790\ud0c0\uc785\uc744 \uc0ac\uc6a9\ud558\ub294 \uac70\uc740 \uc544\ub2c8\ub2e4\n        <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc5f0\uc0b0\uc774 \ud544\uc694\ud55c \uacbd\uc6b0, \uc77c\ub828\ubc88\ud638 \ub4f1\uc758 \uacbd\uc6b0\ub294 \uc22b\uc790\ud0c0\uc785 \uc0ac\uc6a9<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ub2e4\ub978 \uacbd\uc6b0\uc5d0 \uc608\uae30\uce58 \ubabb\ud588\ub358 \ubb38\uc81c \ubc1c\uc0dd \uac00\ub2a5<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n        <\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n\n<\/span><hr><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><ol><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ubb38\uc790\ud0c0\uc785\uc73c\ub85c \ud574\uc57c \ud560 \ud544\uc694 \uac80\ud1a0 : \uc778\ub371\uc2a4\ub85c \uad6c\uc131\ub420 \uc778\uc870\ud0a4, \uad6c\ubd84\ucf54\ub4dc \ub4f1<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ucd5c\ub300\uae38\uc774 \uacb0\uc815\n  <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc22b\uc790\ud0c0\uc785\uc740 \uac00\ubcc0\uae38\uc774\ub85c \uc800\uc7a5\ub41c\ub2e4 : \uc785\ub825\ub41c \uc22b\uc790\ub97c 2\ub85c \ub098\ub208 \uae38\uc774 + \ubd80\ud638 1\ubc14\uc774\ud2b8 (Pack Decimal \ud615\ud0dc)<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n       <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc18c\uc218\uc810 \uc774\ud558 \uc790\ub9ac\uc218 \uacb0\uc815<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ub144\uc6d4\uc77c(YYMMDD) \ud615\ud0dc\uc758 \uacbd\uc6b0 \ubb38\uc790\ud0c0\uc785\uc73c\ub85c \uc9c0\uc815<\/span><\/li><\/ol><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n\n<\/span><h4><a name=\"\uc81c3\uc7a5\ub370\uc774\ud130\ud0c0\uc785\ubc0f\uae38\uc774\uc758\uacb0\uc815-1.4\ub0a0\uc9dc\ud0c0\uc785\"><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">1.4 \ub0a0\uc9dc\ud0c0\uc785<\/span><\/h4><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n<\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc22b\uc790\ud0c0\uc785\uacfc \uac19\uc774 \uc790\uc720\ub85c\uc6b4 \uc5f0\uc0b0 \uac00\ub2a5<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ub0a0\uc9dc \uad00\ub828 \ud2b9\ubcc4 \uae30\ub2a5(Date Functions) \uc0ac\uc6a9 \uac00\ub2a5<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc9c0\uc5ed(\ub098\ub77c)\uc5d0 \ub530\ub77c\uc11c \uc6d0\ud558\ub294 \uc720\ud615\uc73c\ub85c \uc0ac\uc6a9 \uac00\ub2a5<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uacbd\uc6b0\uc5d0 \ub530\ub77c \ubb38\uc81c\ub97c \ubc1c\uc0dd\uc2dc\ud0ac \uc218 \uc788\uc73c\ubbc0\ub85c \ub370\uc774\ud130 \uc18d\uc131\uc5d0 \ub530\ub978 \uc801\uc808\ud55c \uacb0\uc815 \ud544\uc694<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n\n<\/span><h3><a name=\"\uc81c3\uc7a5\ub370\uc774\ud130\ud0c0\uc785\ubc0f\uae38\uc774\uc758\uacb0\uc815-2.\ub370\uc774\ud130\ud0c0\uc785\uc758\uc120\uc815\"><\/a><ins><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">2. \ub370\uc774\ud130 \ud0c0\uc785\uc758 \uc120\uc815<\/span><\/ins><\/h3><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n<\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc5ec\ub7ec\uac1c\uc758 NULL \uceec\ub7fc\uc774 \uc788\ub294 \uacbd\uc6b0\n <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc5f0\uc18d\ub41c NULL \uceec\ub7fc\ub4e4\uc758 \uc804\uccb4 \uc800\uc7a5\uacf5\uac04\uc740 1\ubc14\uc774\ud2b8 \ucc28\uc9c0<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">NULL \uac12\uc774 \uc608\uc0c1\ub418\ub294 \uceec\ub7fc\ub4e4\uc740 \ub418\ub3c4\ub85d \uc5f0\uc18d\uc73c\ub85c \ubc30\uce58\ud558\ub294 \uac83\uc774 \uc720\ub9ac<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n       <\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n\n<\/span><h4><a name=\"\uc81c3\uc7a5\ub370\uc774\ud130\ud0c0\uc785\ubc0f\uae38\uc774\uc758\uacb0\uc815-2.1CHAR\ud0c0\uc785\"><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">2.1 CHAR \ud0c0\uc785<\/span><\/h4><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n<\/span><ol><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">CHAR \ud0c0\uc785 \ud2b9\uc131\n  <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uace0\uc815\uae38\uc774(2\ucc9c\ubc14\uc774\ud2b8\uae4c\uc9c0 \uc785\ub825 \uac00\ub2a5 : 10g \uae30\uc900)<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uae38\uc774\uc9c0\uc815 \uc548\ud558\ub294 \uacbd\uc6b0 1\ubc14\uc774\ud2b8\ub85c \uc790\ub3d9\uc9c0\uc815<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uac12\uc774 \uc785\ub825\ub418\uba74 \ub098\uba38\uc9c0 \uae38\uc774\uac00 \uacf5\ubc31(Blank)\uc73c\ub85c \ucc44\uc6cc\uc9c4\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uac12\uc744 \uc785\ub825\ud558\uc9c0 \uc54a\uc73c\uba74 NULL \uac12\uc774 \uc785\ub825\ub41c\ub2e4(1\ubc14\uc774\ud2b8 \ucc28\uc9c0)<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc9c0\uc815\ub41c \uae38\uc774\ubcf4\ub2e4 \uae34 \uac12 \uc800\uc7a5 \uc2dc\ub3c4\uc2dc \uc5d0\ub7ec \ubc1c\uc0dd<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uac00\ubcc0\uae38\uc774(VARCHAR)\uc5d0 \ube44\ud574 \uc800\uc7a5\uacf5\uac04\uc774 \uc808\uc57d\ub418\uc9c0\ub294 \uc54a\ub294\ub2e4 : \uceec\ub7fc \uae38\uc774\ub97c \ud45c\uc2dc\ud558\ub294 \ubcc4\ub3c4\uc758 \ub0b4\ubd80\uceec\ub7fc \uac00\uc9c0\uace0 \uc788\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uac12 \ube44\uad50\uc2dc \uc218\ud589\uc18d\ub3c4 \uce21\uba74\uc5d0\uc11c \uc720\ub9ac\ud558\uc9c0 \uc54a\uc740 \uacbd\uc6b0\uac00 \ub354 \ub9ce\uc774 \ubc1c\uc0dd<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n  <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">CHAR \ud0c0\uc785 \ud65c\uc6a9 : \ud2b9\ubcc4\ud55c \uacbd\uc6b0\uc5d0 \ud55c\ud574\uc11c\ub9cc \uc0ac\uc6a9\n  <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc800\uc7a5\ub418\ub294 \ubaa8\ub4e0 \ub370\uc774\ud130\uac00 \uace0\uc815\uae38\uc774\ub97c \uac00\uc9c0\ub294 \uacbd\uc6b0\n          <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc608) \ubd80\uc11c\ucf54\ub4dc, \uc0ac\uc6d0\ubc88\ud638, 'YYMMDD'\ub85c \ud45c\uc2dc\ub418\ub294 \ub0a0\uc9dc\uceec\ub7fc<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n                <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uceec\ub7fc\uc758 \uae38\uc774\uac00 \ud55c\uc790\ub9ac\uc778 \uacbd\uc6b0\n           <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ub370\uc774\ud130 \ube44\uad50\uc2dc\uc758 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud558\uc9c0 \uc54a\ub294\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ub370\uc774\ud130 \uac12\uc774 \uc22b\uc790\uc778 \uacbd\uc6b0\ub3c4 NUMBER \ud0c0\uc785\ubcf4\ub2e4 \uc720\ub9ac : NUMBER \ud0c0\uc785\uc740 Pack Decimal \ud615\ud0dc\ub85c \uc800\uc7a5\ub418\uc5b4 \uae38\uc774\uac00 \ub298\uc5b4\ub09c\ub2e4<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n             <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uae30\ud0c0 \ud2b9\ubcc4\ud55c \uacbd\uc6b0\n              <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc800\uc7a5\ub418\ub294 \ubaa8\ub4e0 \ub370\uc774\ud130\uac00 \uc77c\uc815\uae38\uc774 \uc774\uc0c1\uc744 \uac00\uc9c0\uace0 \uae38\uc774\uac00 \uae38\uc9c0 \uc54a\uc740 \uacbd\uc6b0\uc5d0 \uace0\ub824 \uac00\ub2a5 : \ub418\ub3c4\ub85d\uc774\uba74 \uac00\ubcc0\uae38\uc774\ub85c \uc9c0\uc815\ud558\ub294 \uac83\uc774 \uc720\ub9ac<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uac00\ubcc0\uae38\uc774\ub85c \uc9c0\uc815\ud560 \uacbd\uc6b0 \ub9ce\uc740 \uccb4\uc778(Chain) \ubc1c\uc0dd\uc774 \uc6b0\ub824\ub418\ub294 \uacbd\uc6b0 : PCTFREE \uac12\uc744 \uc99d\uac00\uc2dc\ud0a4\uace0 \uac00\ubcc0\uae38\uc774\ub97c \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \uc720\ub9ac<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ub85c\uc6b0 \uc0dd\uc131\uc2dc\uc5d0\ub294 \uceec\ub7fc\uc774 \ucc44\uc6cc\uc9c0\uc9c0 \uc54a\uace0 \uace7 \ubc18\ub4dc\uc2dc \ub370\uc774\ud130\uac00 \uc785\ub825\ub418\ub294 \uacbd\uc6b0\uc758 \uc800\uc7a5\uacf5\uac04 \ud655\ubcf4 : \uac00\ubcc0\uae38\uc774\ub85c \uc9c0\uc815\ud558\uace0 Default Constraint \uc0ac\uc6a9\ud558\uac70\ub098 PCTFREE \uac12\uc744 \uc99d\uac00\uc2dc\ud0a4\ub294 \ubc29\ubc95\uc774 \uc720\ub9ac<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n           <\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n     <\/span><\/li><\/ol><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n\n<\/span><h4><a name=\"\uc81c3\uc7a5\ub370\uc774\ud130\ud0c0\uc785\ubc0f\uae38\uc774\uc758\uacb0\uc815-2.2VARCHAR\ud0c0\uc785\"><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">2.2 VARCHAR \ud0c0\uc785<\/span><\/h4><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n<\/span><ol><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">VARCHAR \ud0c0\uc785 \ud2b9\uc131\n <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uac00\ubcc0\uae38\uc774 \ubb38\uc790\ud0c0\uc785, \ucd5c\ub300 4\ucc9c\ubc14\uc774\ud2b8\uae4c\uc9c0 \uc785\ub825 \uac00\ub2a5(10g \uae30\uc900), \uceec\ub7fc\uae38\uc774 \uc9c0\uc815 \ud544\uc218<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uac12\uc774 \uc785\ub825\ub418\uba74 \ub098\uba38\uc9c0 \uae38\uc774\uac00 \uacf5\ubc31\uc73c\ub85c \ucc44\uc6cc\uc9c0\uc9c0 \uc54a\ub294\ub2e4(\uc785\ub825\ub41c \uac12\ub9cc\ud07c\ub9cc \uc800\uc7a5)<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc785\ub825\ub41c \uac12\uc758 \ub4a4\ucabd\uc5d0 \uacf5\ubc31\uc774 \uc788\ub294 \uacbd\uc6b0 \uacf5\ubc31\ub3c4 \uc800\uc7a5\ub41c\ub2e4(SQL*Forms\uc5d0\uc11c\ub294 \uc790\ub3d9\uc73c\ub85c \uc624\ub978\ucabd \uacf5\ubc31\uc774 \uc81c\uac70\ub418\uc5b4 \uc800\uc7a5\ub418\ub294 \uae30\ub2a5 \uc81c\uacf5)<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc9c0\uc815\ub41c \uae38\uc774\ubcf4\ub2e4 \uae34 \uac12 \uc800\uc7a5 \uc2dc\ub3c4\uc2dc \uc5d0\ub7ec \ubc1c\uc0dd(Validation Check \uc6a9\ub3c4\ub85c \uc0ac\uc6a9)<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uceec\ub7fc\uc758 \uae38\uc774\ub97c \ud45c\uc2dc\ud558\ub294 \ubcc4\ub3c4 \ub0b4\ubd80\uceec\ub7fc\uc774 \uc788\ub2e4(CHAR \ud0c0\uc785\uc5d0\uc11c\ub3c4 \uae38\uc774 \ud45c\uc2dc\uc6a9 \ub0b4\ubd80\uceec\ub7fc\uc774 \uc788\uc73c\ubbc0\ub85c CHAR \ud0c0\uc785\uc774 \uc720\ub9ac\ud558\uc9c0 \uc54a\uc74c)<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">VARCHAR \ud0c0\uc785 \ud65c\uc6a9\n     <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc800\uc7a5\ub418\ub294 \ub370\uc774\ud130\uac00 \uac00\ubcc0\uae38\uc774\ub97c \uac00\uc9c0\ub294 \uacbd\uc6b0(CHAR \ud0c0\uc785\uc73c\ub85c \uc120\uc815\ud574\uc57c \ud558\ub294 \uacbd\uc6b0\ub97c \uc81c\uc678\ud55c \ubaa8\ub4e0 \uacbd\uc6b0)\n          <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">CHAIN \ubc1c\uc0dd\uc744 \ub108\ubb34 \ub450\ub824\uc6cc\ud558\uc9c0 \ub9c8\ub77c\n                      <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ud14c\uc774\ube14\uc758 \uc99d\uac00\uc720\ud615\uc744 \uc608\uc0c1\ud558\uc5ec \uc801\uc808\ud55c PCTFREE \uac12 \ubd80\uc5ec<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc57d\uac04\uc758 CHAIN \ubc1c\uc0dd\uc740 \uac70\uc758 \ub4dc\ub7ec\ub098\uc9c0 \uc54a\ub294\ub2e4<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n                   <\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n             <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ud14c\uc774\ube14\uc744 \ud1b5\ud569\ud588\uc744 \ub54c \uae30\ubcf8\ud0a4 \uac12\uc5d0 \ub530\ub77c \uceec\ub7fc \uac12\uc774 \uc874\uc7ac\ud558\uc9c0 \uc54a\uc744 \uc218 \uc788\ub294 \uceec\ub7fc\n            <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc11c\ube0c\ud0c0\uc785(Subtype) \ud615\ud0dc\ub85c \ub098\ud0c0\ub09c \uc5d4\ud2f0\ud2f0\ub97c \uc218\ud37c\ud0c0\uc785(Supertype)\uc73c\ub85c \uc62c\ub824 \ud558\ub098\uc758 \ud14c\uc774\ube14\ub85c \uc0dd\uc131\uc2dc\ud0a4\uace0\uc790 \ud558\ub294 \uacbd\uc6b0<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc774\ubbf8 \ubd84\ub9ac\ub41c \ud14c\uc774\ube14\uc744 \ud558\ub098\uc758 \ud14c\uc774\ube14\ub85c \ud1b5\ud569\uc2dc\ud0a4\uace0\uc790 \ud558\ub294 \uacbd\uc6b0<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uac01 \uc11c\ube0c\ud0c0\uc785\uc5d0\ub9cc \uc788\ub294 \uceec\ub7fc\ub4e4\uc740 \ubc18\ub4dc\uc2dc VARCHAR \ud0c0\uc785 \uc9c0\uc815<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uac19\uc740 \uc11c\ube0c\ud0c0\uc785\uc5d0 \uc788\ub294 \uceec\ub7fc\ub4e4\uc744 \uc5f0\uc18d\ub418\ub3c4\ub85d \uc9c0\uc815 : NULL \uac12 \ubc1c\uc0dd\uc2dc \uc800\uc7a5\uc7a5\uc18c \uc808\uc57d\ub418\ub3c4\ub85d \ud558\ub294 \uac83\uc774 \uc911\uc694<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n                <\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n     <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">CHAIN \ubc1c\uc0dd\uc774 \uc6b0\ub824\ub418\ub294 \uacbd\uc6b0 \ud655\uc778\ubc29\ubc95\n   <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uccb4\uc778\uc758 \ubc1c\uc0dd\uc815\ub3c4 \ud655\uc778\n<\/span><div class=\"preformatted panel\" style=\"border-width: 1px;\"><div class=\"preformattedContent panelContent\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">ANALYZE TABLE table_name COMPUTE STATISTICS;\n\nSELECT CHAIN_CNT\nFROM   USER_TABLES\nWHERE  TABLE_NAME = 'table_name';\n<\/span><\/pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><\/div><\/div><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uccb4\uc778\uc774 \ubc1c\uc0dd\ud55c \ub85c\uc6b0\ub97c \uc784\uc758\uc758 \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ud558\uc5ec \ud655\uc778\n<\/span><div class=\"preformatted panel\" style=\"border-width: 1px;\"><div class=\"preformattedContent panelContent\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">ANALYZE TABLE table_name\nLIST CHAINED ROWS { INTO chained_table_name };\n\nSELECT *\nFROM   chained_table_name;\n<\/span><\/pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><\/div><\/div><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc800\uc7a5\ud560 \ud14c\uc774\ube14\uba85\uc744 \uc9c0\uc815\ud558\uc9c0 \uc54a\ub294 \uacbd\uc6b0 'CHAINED_ROWS'\ub77c\ub294 \uc2dc\uc2a4\ud15c \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ub41c\ub2e4\n<\/span><div class=\"preformatted panel\" style=\"border-width: 1px;\"><div class=\"preformattedContent panelContent\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">ANALYZE TABLE table_name\nLIST CHAINED ROWS;\n\nSELECT *\nFROM   CHAINED_ROWS\nWHERE  TABLE_NAME = 'table_name';\n<\/span><\/pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><\/div><\/div><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n  <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ud655\uc778\ub41c \uccb4\uc778\uc758 \ub85c\uc6b0\uac00 \ub9ce\uc740 \uacbd\uc6b0 \ud14c\uc774\ube14 \uc7ac\uc0dd\uc131 \uc808\ucc28\n     <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uccb4\uc778\uc774 \ubc1c\uc0dd\ud55c \ub85c\uc6b0\ub97c \ucc3e\uc544 \uc784\uc2dc\ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\n<\/span><div class=\"preformatted panel\" style=\"border-width: 1px;\"><div class=\"preformattedContent panelContent\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">CREATE TABLE temp_table\n AS\n  SELECT *\n  FROM   table_name\n  WHERE  ROWID IN (SELECT HEAD_ROWID\n                   FROM   CHAINED_ROWS\n                   WHERE  TABLE_NAME = 'table_name');\n<\/span><\/pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><\/div><\/div><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uccb4\uc778\uc774 \ubc1c\uc0dd\ud55c \ub85c\uc6b0\ub97c \uc2e4\uc81c \ud14c\uc774\ube14\uc5d0\uc11c \ucc3e\uc544 \uc0ad\uc81c\n<\/span><div class=\"preformatted panel\" style=\"border-width: 1px;\"><div class=\"preformattedContent panelContent\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">DELETE FROM table_name\nWHERE       ROWID IN (SELECT HEAD_ROWID\n                      FROM   CHAINED_ROWS\n                      WHERE  TABLE_NAME = 'table_name');\n<\/span><\/pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><\/div><\/div><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc784\uc2dc\ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ud574 \ub450\uc5c8\ub358 \ub85c\uc6b0\ub97c \uc2e4\uc81c \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ud55c \ud6c4 \uc784\uc2dc\ud14c\uc774\ube14\uacfc 'CHAINED_ROWS' \ud14c\uc774\ube14\uc758 \ud574\ub2f9 \ub85c\uc6b0 \uc0ad\uc81c\n<\/span><div class=\"preformatted panel\" style=\"border-width: 1px;\"><div class=\"preformattedContent panelContent\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">INSERT INTO table_name\nSELECT *\nFROM   temp_table;\n\nDROP TABLE temp_table;\n\nDELETE FROM CHAINED_ROWS\nWHERE       TABLE_NAME = 'table_name';\n<\/span><\/pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><\/div><\/div><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ub2e4\uc2dc ANALYZE \uba85\ub839\uc744 \uc218\ud589\uc2dc\ud0a4\uace0 \uccb4\uc778 \uc5ec\ubd80 \ud655\uc778\n<\/span><div class=\"preformatted panel\" style=\"border-width: 1px;\"><div class=\"preformattedContent panelContent\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">ANALYZE TABLE table_name COMPUTE STATISTICS;\n\nSELECT CHAIN_CNT\nFROM   USER_TABLES\nWHERE  TABLE_NAME = 'table_name';\n<\/span><\/pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><\/div><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><div class=\"panelMacro\"><table class=\"noteMacro\"><colgroup><col width=\"24\"><col><\/colgroup><tbody><tr><td valign=\"top\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/wiki.gurubee.net\/images\/icons\/emoticons\/warning.gif\" alt=\"\" align=\"absmiddle\" width=\"16\" border=\"0\" height=\"16\"><\/td><td><b><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">PCTFREE \ucc38\uace0\uc0ac\ud56d<\/span><\/b><br \/><ol><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc0b0\uc815\ub41c PCTFREE \uac12\uc774 \ub108\ubb34 \ucee4\uc11c \ubd80\ub2f4\uc774 \ub418\ub294 \uacbd\uc6b0\n        <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ud14c\uc774\ube14 \uc0dd\uc131\uc2dc \ud574\ub2f9 \uceec\ub7fc\uc5d0 DEFAULT CONSTRAINT\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc6d0\ud558\ub294 \ub9cc\ud07c\uc758 \uacf5\ubc31\uc744 \uc9c0\uc815\ud558\uc5ec \ubbf8\ub9ac \uc800\uc7a5\uacf5\uac04 \ud655\ubcf4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc0b0\uc815\ub41c PCTFREE \uac12\uc740 \uadf8\ub300\ub85c \uc9c0\uc815\ud574 \uc8fc\ub294 \uac83\uc774 \ubc14\ub78c\uc9c1<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ucd08\uae30\uc5d0 \uc0dd\uc131\ub41c \ud14c\uc774\ube14\uc5d0 \uccb4\uc778\uc774 \ub9ce\uc774 \ubc1c\uc0dd\ud55c \uacbd\uc6b0\uc5d0 \ub370\uc774\ud130\uac00 \uc5b4\ub290\uc815\ub3c4 \ud655\ubcf4\ub41c \uc2dc\uc810\uc5d0\uc11c \uc7ac\uc0dd\uc131\uc2dc\ucf1c \uc8fc\ub294 \ubc29\ubc95\ub3c4 \uc788\ub2e4<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n      <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uccb4\uc778\uc774 \uc6b0\ub824\ub418\uc5b4 \uae30\uc900\uce58(10) \uc774\uc0c1\uc758 PCTFREE\ub97c \uc9c0\uc815\ud55c \uacbd\uc6b0 \uc8fc\uc758\uc810(\uc798\ubabb\ub41c \ubc29\ubc95)\n<\/span><div class=\"preformatted panel\" style=\"border-width: 1px;\"><div class=\"preformattedContent panelContent\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"># \ud14c\uc774\ube14 \uc0dd\uc131 \uc2a4\ud06c\ub9bd\ud2b8\uc5d0 PCTFREE, PCTUSED, STORAGE \ub4f1\uc758 \uac01\uc885 \ud30c\ub77c\uba54\ud130\ub97c \uc800\uc7a5\ud574 \ub454\ub2e4\n# \uae30\uc874\uc758 \ud14c\uc774\ube14\uc758 \uc774\ub984 \ubcc0\uacbd\n# \uc800\uc7a5\ub41c \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uadf8\ub300\ub85c \uc2e4\ud589\ud558\uc5ec \ud14c\uc774\ube14 \uc0dd\uc131 \ud6c4 INSERT\ubb38\uc73c\ub85c \uae30\uc874\uc758 \ub370\uc774\ud130\ub97c \ub2e4\uc2dc \uc785\ub825 \n<\/span><\/pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><\/div><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n     <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc704 \ubc29\ubc95\uc740 \uc544\uc8fc \uc798\ubabb\ub41c \ubc29\ubc95\n             <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uae30\uc874 \ub370\uc774\ud130\ub294 \ucd5c\ucd08 \uc800\uc7a5 \uc774\ud6c4 \ub098\uba38\uc9c0 \uac12\uc774 UPDATE\ub418\uc5b4 \uc774\ubbf8 \ub85c\uc6b0\uac00 \uc644\uc131\ub418\uc5b4 \uc788\ub2e4 : \uae30\uc874\uc758 \ub370\uc774\ud130\ub294 \uc774\uc81c \ub354\uc774\uc0c1 \ub298\uc5b4\ub098\uc9c0 \uc54a\ub294 \uacbd\uc6b0\uac00 \ub9ce\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc774\ubbf8 \ub298\uc5b4\ub09c \ub85c\uc6b0\ub97c \uc704\ud574\uc11c PCTFREE\ub97c \ucd94\uac00\ub85c \uc9c0\uc815\ud55c \ud6a8\uacfc : \ube14\ub7ed\ub2f9 \uc800\uc7a5\ub418\ub294 \ub85c\uc6b0\uc218\uac00 \uc904\uc5b4\ub4e4\uc5b4 \uc800\uc7a5\uacf5\uac04 \ub0ad\ube44 \ucd08\ub798 \ubc0f \uc218\ud589\uc18d\ub3c4 \uc800\ud558<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n           <\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n     <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc62c\ubc14\ub978 \ubc29\ubc95\uc740?(\uc791\uc131\uc790\uc758 \uc758\uacac)\n<\/span><div class=\"preformatted panel\" style=\"border-width: 1px;\"><div class=\"preformattedContent panelContent\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"># \ud14c\uc774\ube14 \uc0dd\uc131\uc2dc PCTFREE \uac12\uc744 \uae30\ubcf8\uac12(10) \ub610\ub294 \ub354 \uc791\uc740 \uac12\uc73c\ub85c \uc9c0\uc815\ud558\uc5ec \uc0dd\uc131\ud55c\ub2e4\n# INSERT\ubb38\uc73c\ub85c \uae30\uc874\uc758 \ub370\uc774\ud130\ub97c \uc785\ub825\ud55c\ub2e4\n# ALTER TABLE \uba85\ub839\uc73c\ub85c PCTFREE \uac12\uc744 \ub298\ub824\uc900\ub2e4\n<\/span><\/pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><\/div><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n   <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc8fc\uc758\uc0ac\ud56d\n               <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">NonPartitioned Table\uc758 \uacbd\uc6b0\uc5d0\ub9cc \ud574\ub2f9<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ucd94\uac00\uc801\uc73c\ub85c DBMS_REPAIR.SEGMENT_FIX_STATUS \ud504\ub85c\uc2dc\uc838\ub97c \uc218\ud589\ud558\uc5ec \uc774\ubbf8 \uc800\uc7a5\ub41c \ube14\ub7ed\uc5d0 \ub300\ud574\uc11c \uc801\uc6a9\ub418\ub3c4\ub85d \ud574\uc918\uc57c \ud55c\ub2e4<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n            <\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n     <\/span><\/li><\/ol><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><\/td><\/tr><\/tbody><\/table><\/div><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n  <\/span><\/li><\/ol><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n\n<\/span><h4><a name=\"\uc81c3\uc7a5\ub370\uc774\ud130\ud0c0\uc785\ubc0f\uae38\uc774\uc758\uacb0\uc815-2.3\ubb38\uc790\ud0c0\uc785\uc758\ube44\uad50\ubc95\uce59\"><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">2.3 \ubb38\uc790\ud0c0\uc785\uc758 \ube44\uad50\ubc95\uce59<\/span><\/h4><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n<\/span><ol><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">CHAR vs. CHAR<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><img decoding=\"async\" src=\"http:\/\/wiki.gurubee.net\/download\/attachments\/688175\/char_char.gif\" align=\"absmiddle\" border=\"0\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n     <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ub450 \uceec\ub7fc \uc911 \uae38\uc774\uac00 \uc9e7\uc740 \uceec\ub7fc\uc5d0 \uacf5\ubc31\uc744 \ucd94\uac00\ud558\uc5ec \uae38\uc774\ub97c \ub3d9\uc77c\ud558\uac8c \ud55c\ub2e4\n             <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc704 \uadf8\ub9bc\uc758 \uacbd\uc6b0 C2 \uceec\ub7fc\uc5d0 197\uac1c\uc758 \uacf5\ubc31\uc774 \ucd94\uac00\ub41c\ub2e4<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n              <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uac01\uac01\uc758 \ubb38\uc790\ub97c \ube44\uad50\ud558\uc5ec \uc11c\ub85c \ub2e4\ub978 \uac12\uc774 \ub098\ud0c0\ub098\uba74 \ubb38\uc790\uac12\uc774 \ud070 \uceec\ub7fc\uc774 \ud06c\ub2e4\uace0 \ud310\ub2e8\ud558\uace0 \ube44\uad50\ub97c \uc885\ub8cc\n         <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uac12\uc774 \uac19\uc740 \uacbd\uc6b0 \uc804\uccb4 \ubb38\uc790\ub97c \ubaa8\ub450 \ube44\uad50(\uacf5\ubc31 \ud3ec\ud568)<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n               <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ube44\uad50\uc791\uc5c5\uc740 \uae38\uc774\uac00 \uae34 \uceec\ub7fc\ub9cc\ud07c \uc218\ud589\ub418\ubbc0\ub85c \uc218\ud589\uc18d\ub3c4 \uc800\ud558<br \/><br \/><b><br \/><\/b><\/span><\/li><\/ul><b><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n   <\/span><\/b><li><b><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">CHAR vs. VARCHAR<\/span><\/b><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><img decoding=\"async\" src=\"http:\/\/wiki.gurubee.net\/download\/attachments\/688175\/char_varchar.gif\" align=\"absmiddle\" border=\"0\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n       <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ubb38\uc790\uac12 \ube44\uad50\uac00 \uba3c\uc800 \uc218\ud589\ub41c\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uac01\uac01\uc758 \ubb38\uc790\ub97c \ube44\uad50\ud558\uc5ec \uc11c\ub85c \ub2e4\ub978 \uac12\uc774 \ub098\ud0c0\ub098\uba74 \ubb38\uc790\uac12\uc774 \ud070 \uceec\ub7fc\uc774 \ud06c\ub2e4\uace0 \ud310\ub2e8\ud558\uace0 \ube44\uad50\ub97c \uc885\ub8cc\n               <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc704 \uadf8\ub9bc\uc5d0\uc11c\ub294 3\uac1c\uc758 \ubb38\uc790\uae4c\uc9c0\ub9cc \ube44\uad50, 'C1 &gt; V1'\uc758 \uacb0\uacfc\uac00 \ub098\ud0c0\ub09c\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc800\uc7a5\ub41c \uacb0\uacfc\uac00 \uac19\ub354\ub77c\ub3c4 '\uc11c\ub85c \uac19\uc9c0 \uc54a\ub2e4'\ub294 \uacb0\uacfc\uac00 \ub098\ud0c0\ub098\ubbc0\ub85c \ud568\ubd80\ub85c CHAR \ud0c0\uc785 \uc9c0\uc815\ud558\uc9c0 \uc54a\ub294\ub2e4<br \/><br \/><br \/><\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n         <\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n     <\/span><\/li><li><b><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">VARCHAR vs. VARCHAR<\/span><\/b><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><img decoding=\"async\" src=\"http:\/\/wiki.gurubee.net\/download\/attachments\/688175\/varchar_varchar.gif\" align=\"absmiddle\" border=\"0\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n        <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ubb38\uc790\uac12 \ube44\uad50\uac00 \uba3c\uc800 \uc218\ud589\ub41c\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uac01\uac01\uc758 \ubb38\uc790\ub97c \ube44\uad50\ud558\uc5ec \uc11c\ub85c \ub2e4\ub978 \uac12\uc774 \ub098\ud0c0\ub098\uba74 \ubb38\uc790\uac12\uc774 \ud070 \uceec\ub7fc\uc774 \ud06c\ub2e4\uace0 \ud310\ub2e8\ud558\uace0 \ube44\uad50\ub97c \uc885\ub8cc\n               <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc800\uc7a5\ub41c \ub370\uc774\ud130 \uac12\uc774 \uac19\ub2e4\uba74 \ub3d9\uc77c\ud55c \uae38\uc774\ub97c \uac00\uc9c0\uba70, \uc704\uc758 \uc608\uc5d0\uc11c\ub294 'V1 = V2'\ub77c\ub294 \uacb0\uacfc\uac00 \ub098\ud0c0\ub09c\ub2e4<br \/><br \/><br \/><\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n               <\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n     <\/span><\/li><li><b><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc0c1\uc218\uac12\uc758 \ube44\uad50\n      <\/span><\/b><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">CHAR vs. \uc0c1\uc218\uac12\n            <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">C1\uc744 CHAR(200)\uc73c\ub85c \uc9c0\uc815\ud558\uc600\ub2e4\uace0 \uac00\uc815\ud558\uace0 C1 = 'ABC'\ub97c \ube44\uad50<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">'ABC'\ub294 C1\uacfc \ub3d9\uc77c\ud55c CHAR(200)\uc73c\ub85c \ubcc0\ud658\ub418\uc5b4 \ube44\uad50 \uc218\ud589\ub41c\ub2e4 : CHAR vs. CHAR \uacfc \uac19\uc740 \ubc29\uc2dd\uc73c\ub85c \uc218\ud589<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n          <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">VARCHAR vs. \uc0c1\uc218\uac12\n            <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">V1\uc744 VARCHAR2(200)\uc73c\ub85c \uc9c0\uc815\ud558\uc600\ub2e4\uace0 \uac00\uc815\ud558\uace0 V1 = 'ABC'\ub97c \ube44\uad50<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">'ABC'\ub294 VARCHAR2 \ud0c0\uc785\uc774 \ub418\ubbc0\ub85c VARCHAR vs. VARCHAR \uc640 \uac19\uc740 \ubc29\uc2dd\uc73c\ub85c \uc218\ud589<br \/><br \/><br \/><\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n          <\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n     <\/span><\/li><li><b><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ubb38\uc790\ud0c0\uc785\uc758 \ube44\uad50\ubc95\uce59 \uc815\ub9ac<\/span><\/b><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><img decoding=\"async\" src=\"http:\/\/wiki.gurubee.net\/download\/attachments\/688175\/literal_compare.gif\" align=\"absmiddle\" border=\"0\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n   <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">CHAR \ud0c0\uc785\uacfc VARCHAR2 \ud0c0\uc785\uc744 \ub3d9\uc77c\ud558\uac8c 7\uc790\ub9ac\ub85c \uc9c0\uc815\ud55c \ud6c4 'ABC' \uc785\ub825\n            <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">CHAR \ud0c0\uc785\uc5d0\ub294 4\uc790\ub9ac\uc758 \uacf5\ubc31\uc774 \ucc44\uc6cc\uc9c0\uace0 VARCHAR2 \ud0c0\uc785\uc5d0\ub294 'ABC'\ub9cc \uc800\uc7a5\ub418\uace0 \uae38\uc774\ub294 3\uc774 \ub41c\ub2e4<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n            <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ube44\uad50\uacb0\uacfc\n              <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">1), 2) \ubc88\uc758 \uacbd\uc6b0\ub294 \uc815\uc0c1\uc801\uc778 \ube44\uad50\uacb0\uacfc\ub97c \uc5bb\uc744 \uc218 \uc788\uc73c\ub098 3) \uc758 \uacbd\uc6b0\uc5d0\ub294 COL1\uc774 \ud06c\ub2e4\ub294 \uacb0\uacfc\uac00 \ub098\ud0c0\ub09c\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">COL1 = 'ABC' \uc774\uace0, COL2 = 'ABC' \uc774\uba74 \ub2f9\uc5f0\ud788 COL1 = COL2 \uac00 \ub418\uc5b4\uc57c \ud568\uc5d0\ub3c4 \ubd88\uad6c\ud558\uace0 \uc11c\ub85c \ub2e4\ub974\ub2e4\ub294 \uacb0\uacfc\uac00 \ub098\ud0c0\ub09c\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uacb0\ub860 : CHAR \ud0c0\uc785\uc740 \uc0ac\uc6a9\ud558\ub418 \ubc18\ub4dc\uc2dc '\uc57d\uc18d\uc774 \uc120\ud589'\ub41c \uc0c1\ud0dc\uc5d0\uc11c \uc0ac\uc6a9\ud574\uc57c \ud558\uba70, \uac00\ub2a5\ud55c VARCHAR \ud0c0\uc785\uc744 \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \uc720\ub9ac\ud558\ub2e4<br \/><br \/><br \/><\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n              <\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n     <\/span><\/li><\/ol><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n\n<\/span><h4><a name=\"\uc81c3\uc7a5\ub370\uc774\ud130\ud0c0\uc785\ubc0f\uae38\uc774\uc758\uacb0\uc815-2.4NUMBER\ud0c0\uc785\"><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">2.4 NUMBER \ud0c0\uc785<\/span><\/h4><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n<\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc22b\uc790\ub97c \uc800\uc7a5\ud558\ub294 \ub370\uc774\ud130 \ud0c0\uc785<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uac00\ubcc0\uae38\uc774\ub85c \uc800\uc7a5<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc22b\uc790\ub77c\uace0 \ud574\uc11c \ubc18\ub4dc\uc2dc NUMBER \ud0c0\uc785\uc744 \uc368\uc57c \ud558\ub294 \uac83\uc740 \uc544\ub2c8\ub2e4\n  <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ube44\uad50\uac00 \uc77c\uc5b4\ub0a0 \ub54c \ubcc0\ud654\uac00 \uc77c\uc5b4\ub098\ub294 \ud2b9\uc131\uc744 \uc815\ud655\ud788 \uc54c\uace0 \uc0ac\uc6a9\ud574\uc57c \ud55c\ub2e4<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n     <\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n\n<\/span><hr><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><ol><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">NUMBER \ud0c0\uc785 \ud2b9\uc131\n   <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ud45c\ud604 \uac00\ub2a5\ud55c \ubc94\uc704\n               <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc601(Zero), \uc74c\uc218, \uc591\uc218, \uc18c\uc218\uc810<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">1.0 * 10 <\/span><sup><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">-130<\/span><\/sup><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> ~ 9.9 * 10 <\/span><sup><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">125<\/span><\/sup><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \uae4c\uc9c0 \uac00\ub2a5<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uceec\ub7fc \uae38\uc774\ub294 38\uc790\ub9ac\uae4c\uc9c0 \uc9c0\uc815 \uac00\ub2a5<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc18c\uc218\uc810 \uc9c0\uc815\uc740 -84 ~ 127\uc790\ub9ac\uae4c\uc9c0 \uac00\ub2a5<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n              <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ud329\ub370\uc2dc\uba40(Pack Decimal) \ud615\ud0dc\ub85c \uc800\uc7a5 : (\uc785\ub825\ub41c \uc22b\uc790\uc758 \uae38\uc774\/2) + 1\n               <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc800\uc7a5\uacf5\uac04\uc744 \uc808\uc57d\ud560 \uc218 \uc788\ub2e4(1\uc790\ub9ac \uc22b\uc790\uc758 \uacbd\uc6b0\ub294 \uc800\uc7a5\uacf5\uac04 \ub0ad\ube44\ub418\ubbc0\ub85c CHAR \ud0c0\uc785 \uc0ac\uc6a9)<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ube44\uad50 \uc218\ud589\uc2dc \ubcc0\ud654\uc5d0 \uc758\ud574\uc11c \uacbd\uc6b0\uc5d0 \ub530\ub77c \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud558\uc9c0 \ubabb\ud560\uc218\ub3c4 \uc788\ub2e4<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n                <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc18c\uc218\uc810 \uc790\ub9ac\uc218 \uc9c0\uc815\n            <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc18c\uc218\uc810\uc744 \uc9c0\uc815\ud558\uc9c0 \uc54a\uc558\uac70\ub098 \uc9c0\uc815\ub41c \uc18c\uc218\uc810\uc790\ub9ac \uc774\uc0c1 \uc785\ub825\uc2dc : \uc5d0\ub7ec \uc5c6\uc774 \uc9c0\uc815\ub41c \uc790\ub9ac\ub85c \uc790\ub3d9 \ubc18\uc62c\ub9bc\ub418\uc5b4 \uc800\uc7a5\ub428<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc0ac\uc6a9\ud560 \uc18c\uc218\uc810 \uc790\ub9ac\ub97c \uc815\ud655\ud788 \uc9c0\uc815\ud574\uc57c \ud55c\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc74c\uc218(-)\uc758 \uc18c\uc218\uc810 \uc9c0\uc815\uc2dc : \uc815\uc218\uc790\ub9ac\ucabd(\uc88c\uce21)\uc73c\ub85c \uc9c0\uc815\ud55c \ub9cc\ud07c \ubc18\uc62c\ub9bc\ub418\uc5b4 \uc808\uc0ac \ucc98\ub9ac\ub41c\ub2e4<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n         <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc608\uc2dc 1) NUMBER(5)\ub85c \uc9c0\uc815\ub41c \uceec\ub7fc\n               <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">0, -5, 30 \uc785\ub825 : \uc785\ub825\ud55c \uac12\uc774 \uadf8\ub300\ub85c \uc800\uc7a5\ub41c\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">123.56 \uc785\ub825 : 124\ub85c \ubc18\uc62c\ub9bc\ub41c \uac12\uc774 \uc800\uc7a5\ub41c\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">123456 \uc785\ub825 : \uae38\uc774\ucd08\uacfc\ub85c \uc5d0\ub7ec \ubc1c\uc0dd<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n              <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc608\uc2dc 2) NUMBER(5,2)\ub85c \uc9c0\uc815\ub41c \uceec\ub7fc\n             <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">0, 123.45 \uc785\ub825 : \uc785\ub825\ud55c \uac12\uc774 \uadf8\ub300\ub85c \uc800\uc7a5\ub41c\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">123.456 \uc785\ub825 : \uc18c\uc218\uc810 3\ubc88\uc9f8 \uc790\ub9ac\uc5d0\uc11c \ubc18\uc62c\ub9bc\ub418\uc5b4 123.46 \uc800\uc7a5<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">1234.56 \uc785\ub825 : \uae38\uc774\ucd08\uacfc\ub85c \uc5d0\ub7ec \ubc1c\uc0dd<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n            <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc608\uc2dc 3) NUMBER(5,-2)\ub85c \uc9c0\uc815\ub41c \uceec\ub7fc\n            <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">12345, 123.45 \uc785\ub825 : 10\ub2e8\uc704\uc5d0\uc11c \ubc18\uc62c\ub9bc\ub418\uc5b4 \uac01\uac01 12300, 100 \uc800\uc7a5<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">30 \uc785\ub825 : 0 \uc800\uc7a5<br \/><br \/><br \/><\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n             <\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n     <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">NUMBER \ud0c0\uc785 \ud65c\uc6a9\n      <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc5f0\uc0b0\uc774 \ud544\uc694\ud55c \uceec\ub7fc\n             <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uac00\ubcc0\uae38\uc774\ub85c \uc800\uc7a5\ub418\ubbc0\ub85c \uc815\uc218\ubd80\ubd84\uc740 \ucda9\ubd84\ud788 \uc9c0\uc815\ud574\ub3c4 \ubb34\ubc29(\ud2b9\ubcc4\ud788 \uae38\uc774\uc81c\ud55c \ud544\uc694 \uc5c6\ub294 \uacbd\uc6b0 \uadf8\ub0e5 NUMBER\ub85c \uc9c0\uc815)<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc18c\uc218\uc810\uc740 \ubc18\uc62c\ub9bc\ub418\uc5b4 \uc800\uc7a5\ub418\ubbc0\ub85c \uc0ac\uc6a9\ud560 \uac12\uc744 \uac10\uc548\ud558\uc5ec \uc18c\uc218\uc810 \uc790\ub9bf\uc218 \uacb0\uc815<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n                <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uae30\ubcf8\ud0a4\uc5d0 \ud3ec\ud568\ub418\ub294 \uc77c\ub828\ubc88\ud638 : \ubc18\ub4dc\uc2dc \uc22b\uc790\ud0c0\uc785\uc73c\ub85c \uc9c0\uc815\n         <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">'00001'\uacfc \uac19\uc740 \ubb38\uc790\ud0c0\uc785 \uc0ac\uc6a9\uc740 \uc800\uc7a5\uacf5\uac04 \ub0ad\ube44 \ubc0f \uc0ac\uc6a9\uc0c1 \ubd88\ud3b8<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">LIKE \uac80\uc0c9\uc744 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub294\ub2e4 : \ubc94\uc704\ucc98\ub9ac \ud544\uc694\uc2dc BETWEEN \uc0ac\uc6a9<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n               <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ubb38\uc790\ud0c0\uc785\uacfc \ube44\uad50\uc2dc \uc0c1\ub300 \ubb38\uc790\ud0c0\uc785\uc744 \uc22b\uc790\ub85c \ubc14\uafb8\uc5b4 \ube44\uad50\n          <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ub0b4\ubd80\uc801\uc778 \uc0ac\uc6a9\uc81c\ud55c \ubc1c\uc0dd\uc2dc\ud0a8\ub2e4 : \uc6d0\ud558\uc9c0 \uc54a\ub294 \uc561\uc138\uc2a4 \uacbd\ub85c \uc0dd\uc131<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc778\ub371\uc2a4\ub85c \uc0dd\uc131\ud560 \uceec\ub7fc\uc740 \ubb38\uc790\ud0c0\uc785\uc73c\ub85c \ud558\ub294 \uac83\uc774 \uc88b\ub2e4<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n         <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">LIKE 'char%' \ube44\uad50\uc2dc \ubb38\uc790\ud0c0\uc785\uc73c\ub85c \ubc14\ub00c\ubbc0\ub85c \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub294\ub2e4\n          <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc778\ub371\uc2a4\ub85c \uc0dd\uc131\ud560 \uceec\ub7fc\uc740 \ubc18\ub4dc\uc2dc \ubb38\uc790\ud0c0\uc785\uc73c\ub85c \uc9c0\uc815<br \/><br \/><br \/><\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n             <\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n     <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">10g \uc2e0\uaddc \uc22b\uc790\ud0c0\uc785 : BINARY_FLOAT, BINARY_DOUBLE\n       <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">NUMBER \ud0c0\uc785\uc744 \ubcf4\uc644\ud558\uae30 \uc704\ud574 \ucd94\uac00\ub41c \uc22b\uc790 \ud0c0\uc785<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">IEEE(Institute for Electrical and Electronic Engineering)\uc758 \ubd80\ub3d9\uc18c\uc218\uc810 \ud45c\uae30 \ud45c\uc900\uc5d0 \uae30\ubc18\ud55c \ud0c0\uc785<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">NUMBER \ud0c0\uc785\uc5d0 \ube44\ud574 \uc801\uc740 \uc800\uc7a5\uacf5\uac04 \ucc28\uc9c0\n                <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">NUMBER \ud0c0\uc785 : \ucd5c\ub300 22\ubc14\uc774\ud2b8\uae4c\uc9c0 \ucc28\uc9c0<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">BINARY_FLOAT \ud0c0\uc785 : 5\ubc14\uc774\ud2b8 \ucc28\uc9c0(Single precision 32-bit floating point number)<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">BINARY_DOUBLE \ud0c0\uc785 : 9\ubc14\uc774\ud2b8 \ucc28\uc9c0(Double precision 64-bit floating point number)<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n           <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">NUMBER \ud0c0\uc785\uc5d0 \ube44\ud574 \ub113\uc740 \uc5ed\uc5ed\uc744 \ud45c\uc2dc \uac00\ub2a5 : \ud06c\uac70\ub098 \uc791\uc740 \uc601\uc5ed<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc77c\ubc18\uc801\uc73c\ub85c NUMBER \ud0c0\uc785\ubcf4\ub2e4 \uc5f0\uc0b0\uc18d\ub3c4\uac00 \ube60\ub974\ub2e4 : H\/W\uc5d0\uc11c \uc9c1\uc811 \uc5f0\uc0b0 \uc218\ud589(NUMBER \ud0c0\uc785\uc740 \ubcc0\ud658\uc774 \uc120\ud589\ub418\uc5b4\uc57c \ud55c\ub2e4)<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ub2eb\ud78c \uc5f0\uc0b0 \uc218\ud589\n          <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc5f0\uc0b0\uacb0\uacfc \uc22b\uc790 \ub610\ub294 \ud2b9\uc218\uac12\uc774 \ub9ac\ud134\ub41c\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ud2b9\uc218\uac12 \ubaa9\ub85d\n<\/span><table class=\"confluenceTable\"><tbody>\n<tr>\n<th class=\"confluenceTh\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">Special Value<\/span><\/th>\n<th class=\"confluenceTh\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">Description<\/span><\/th>\n<\/tr>\n<tr>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">BINARY_FLOAT_NAN<\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">Not a number(NaN)<\/span><\/td>\n<\/tr>\n<tr>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">BINARY_FLOAT_INFINITY<\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">Infinity(INF)<\/span><\/td>\n<\/tr>\n<tr>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">BINARY_DOUBLE_NAN<\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">Not a number(NaN)<\/span><\/td>\n<\/tr>\n<tr>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">BINARY_DOUBLE_INFINITY<\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">Infinity(INF)<\/span><\/td>\n<\/tr>\n<\/tbody><\/table><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n                <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uba85\ub8cc\ud55c \ubc18\uc62c\ub9bc\n         <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">NUMBER \ud0c0\uc785\uc774 10\uc9c4\uc218\ub97c \uc0ac\uc6a9\ud558\ub294 \uac83\uc5d0 \ube44\ud574 2\uc9c4\uc218 \uc0ac\uc6a9 : \uac00\uc7a5 \uac00\uae4c\uc6b4 2\uc9c4\uc218\ub85c \ubc18\uc62c\ub9bc \ucc98\ub9ac\ub428<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n              <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc0ac\uc6a9 \uc608\uc2dc\n<\/span><div class=\"preformatted panel\" style=\"border-width: 1px;\"><div class=\"preformattedContent panelContent\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">CREATE TABLE binary_test (\n  bin_float BINARY_FLOAT,\n  bin_double BINARY_DOUBLE\n);\n\nINSERT INTO binary_test (\n  bin_float, bin_double\n) VALUES (\n  39.5f, 15.7d\n);\n\nINSERT INTO binary_test (\n  bin_float, bin_double\n) VALUES (\n  BINARY_FLOAT_INFINITY, BINARY_DOUBLE_INFINITY\n);\n<\/span><\/pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><\/div><\/div><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc218\uce58 \uc5f0\uc0b0\uc774 \ub9ce\uc774 \uc218\ubc18\ub418\ub294 \uc5b4\ud50c\ub9ac\ucf00\uc774\uc158 \uac1c\ubc1c\uc2dc BINARY_FLOAT\uc640 BINARY_DOUBLE\uc744 \uc0ac\uc6a9\ud558\ub294 \uac83\uc744 \uace0\ub824\ud560\uac83<br \/><br \/><br \/><\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n  <\/span><\/li><\/ol><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n\n<\/span><h4><a name=\"\uc81c3\uc7a5\ub370\uc774\ud130\ud0c0\uc785\ubc0f\uae38\uc774\uc758\uacb0\uc815-2.5DATE\ud0c0\uc785\"><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">2.5 DATE \ud0c0\uc785<\/span><\/h4><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n<\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ub0a0\uc9dc\ub97c \uc800\uc7a5\ud558\ub294 \ub370\uc774\ud130 \ud0c0\uc785<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uace0\uc815\uae38\uc774\ub85c \uc800\uc7a5\ub418\ub098 \ubcf4\uc5ec\uc9c0\ub294 \ud615\ud0dc\ub294 \ub2e4\ub974\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ud2b9\uc815\ud55c \uacbd\uc6b0 \ube44\uad50\uc5d0\uc11c\ub294 \uceec\ub7fc\uc758 \ub0b4\ubd80\uc801 \ubcc0\ud615\uc774 \ubc1c\uc0dd\ud558\uc5ec \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud558\uc9c0 \ubabb\ud558\ub294 \uacbd\uc6b0\ub3c4 \uc788\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc22b\uc790\ucc98\ub7fc \ub367\uc148 \ubc0f \ube84\uc148\uc774 \uac00\ub2a5<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ub2e4\uc591\ud55c \ub0a0\uc9dc\ucc98\ub9ac\ud568\uc218 \uc774\uc6a9<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n\n<\/span><ol><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">DATE \ud0c0\uc785 \ud2b9\uc131\n  <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ub144\ub3c4(\uc138\uae30 \ud3ec\ud568), \uc6d4, \uc77c, \uc2dc, \ubd84, \ucd08\ub85c \uad6c\uc131\ub41c \ub0a0\uc9dc\uc640 \uc2dc\uac04\uc744 \uc800\uc7a5<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">BC 4712\ub144 1\uc6d4 1\uc77c ~ AD 4712\ub144 12\uc6d4 31\uc77c\uae4c\uc9c0 \uc800\uc7a5\ud560 \uc218 \uc788\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ub2e4\uc591\ud55c \ub0a0\uc9dc\ucc98\ub9ac\ud568\uc218\ub97c \uc774\uc6a9\ud558\uc5ec \uc6b0\ub9ac\uac00 \uc6d0\ud558\ub294 \ud615\ud0dc\ub85c \ucd9c\ub825\ubc1b\uc744 \uc218 \uc788\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc800\uc7a5\ub418\ub294 \ud615\ud0dc\uc640 \ubcf4\uc5ec\uc9c0\ub294 \ud615\ud0dc\uac00 \uc77c\uce58\ud558\uc9c0 \uc54a\ub294\ub2e4 : \ube44\uad50 \uc218\ud589\uc2dc \ud0c0\uc785 \ubcc0\ud654 \uc218\ubc18\ub418\ub294 \ubb38\uc81c\uc810 \ub0b4\ud3ec<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">DATE \ud0c0\uc785 \uceec\ub7fc\uc5d0\ub294 \uc2dc\ubd84\ucd08\uae4c\uc9c0 \uc800\uc7a5\ub41c\ub2e4 : \uc870\uac74\ube44\uad50\uc2dc \uc0c1\uc218\uac12\uc740 \uc8fc\ub85c \ub0a0\uc9dc\uae4c\uc9c0\ub9cc \uc9c0\uc815\ud558\ubbc0\ub85c '='\ub85c \ube44\uad50\ud558\ub294 \uacbd\uc6b0 \uc6d0\ud558\ub294 \uacb0\uacfc\ub97c \uc5bb\uc744 \uc218 \uc5c6\ub2e4\n              <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc608\uc2dc) '95\ub144 9\uc6d4 1\uc77c'\uc5d0 EMP \ud14c\uc774\ube14\uc5d0 \uc544\ub798\uc640 \uac19\uc774 \ub370\uc774\ud130\ub97c \uc785\ub825\ud588\ub2e4\uace0 \uac00\uc815\n<\/span><table class=\"confluenceTable\"><tbody>\n<tr>\n<th class=\"confluenceTh\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">empno<\/span><\/th>\n<th class=\"confluenceTh\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">ename<\/span><\/th>\n<th class=\"confluenceTh\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">job<\/span><\/th>\n<th class=\"confluenceTh\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">sal<\/span><\/th>\n<th class=\"confluenceTh\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">hiredate<\/span><\/th>\n<th class=\"confluenceTh\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">deptno<\/span><\/th>\n<\/tr>\n<tr>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">7788<\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">'\ud64d\uae38\ub3d9'<\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">'\uc5d4\uc9c0\ub2c8\uc5b4'<\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">3000000<\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">sysdate<\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">10<\/span><\/td>\n<\/tr>\n<tr>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">7823<\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">'\ubc15\ubb38\uc218'<\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">'\uc601\uc5c5\uc0ac\uc6d0'<\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">3200000<\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">'01-sep-95'<\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">30<\/span><\/td>\n<\/tr>\n<\/tbody><\/table><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><div class=\"preformatted panel\" style=\"border-width: 1px;\"><div class=\"preformattedContent panelContent\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">SELECT *\nFROM   EMP\nWHERE  hiredate = '01-sep-95';\n<\/span><\/pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><\/div><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n                 <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc704\uc758 SQL\uc744 \uc218\ud589\uc2dc\ud0a8 \uacb0\uacfc\ub294 '\ubc15\ubb38\uc218'\ub9cc \ucd94\ucd9c\ub41c\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">'\ud64d\uae38\ub3d9'\uc740 \uc785\ub825\ud55c \uc21c\uac04\uc758 \uc815\ud655\ud55c \uc2dc\uac04\uc774 \uc800\uc7a5\ub418\uace0, SQL\uc5d0\uc11c \ubd80\uc5ec\ud55c \uc0c1\uc218\uac12\uc740 \uc9c0\uc815\ub41c \uc2dc\uac04\uc774 \uc5c6\uc73c\ubbc0\ub85c \ube44\uad50\ub420 \ub54c '00\uc2dc 00\ubd84 00\ucd08'\ub77c\ub294 \uc2dc\uac04\uc744 \uac00\uc9c4 DATE\ub85c \ubcc0\ud654\ub418\uc5b4 \ub0a0\uc9dc\ub294 \uac19\ub354\ub77c\ub3c4 \uc2dc\uac04\uc774 \ub2e4\ub974\ubbc0\ub85c \ucd94\ucd9c\ub418\uc9c0 \uc54a\uac8c \ub41c\ub2e4<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n                     <\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n             <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ub144\ub3c4\ub098 \ub0a0\uc9dc\ub97c \ube44\uad50\ud560 \ub54c \uc77c\ubc18 \ubb38\uc790\ud0c0\uc785\ucc98\ub7fc 'LIKE'\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4\n           <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc0c1\uc218\uac12\uc5d0 \uc0ac\uc6a9\ub41c '%'\ub97c DATE \ud0c0\uc785\uc73c\ub85c \ubcc0\ud654\uc2dc\ud0ac \uc218 \uc5c6\uc73c\ubbc0\ub85c \uceec\ub7fc \uc790\uc2e0\uc744 'TO_CHAR'\ub85c \ubcc0\ud654\uc2dc\ud0a8\ub2e4 : \uceec\ub7fc\uc5d0 \ub0b4\ubd80\uc801\uc778 \ubcc0\uacbd\uc774 \uc77c\uc5b4\ub098 \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uac8c \ub41c\ub2e4<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n          <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uae30\uc874\uc5d0 \uc815\uc758\ud55c DATE \ud0c0\uc785\uc744 \ub3c4\uc800\ud788 \uc218\uc815\ud560 \uc218 \uc5c6\ub294 \uacbd\uc6b0\uc758 \ud574\uacb0\n<\/span><div class=\"preformatted panel\" style=\"border-width: 1px;\"><div class=\"preformattedContent panelContent\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">SELECT *\nFROM   EMP\nWHERE  hiredate BETWEEN '01-sep-95' and to_date('01-sep-95') + 0.99999;\n<\/span><\/pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><\/div><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><div class=\"panelMacro\"><table class=\"warningMacro\"><colgroup><col width=\"24\"><col><\/colgroup><tbody><tr><td valign=\"top\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/wiki.gurubee.net\/images\/icons\/emoticons\/forbidden.gif\" alt=\"\" align=\"absmiddle\" width=\"16\" border=\"0\" height=\"16\"><\/td><td><b><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc798\ubabb\ub41c SQL \uc0ac\uc6a9 \uc608 : \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\ub2e4<\/span><\/b><br \/><div class=\"preformatted panel\" style=\"border-width: 1px;\"><div class=\"preformattedContent panelContent\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">SELECT *\nFROM   EMP\nWHERE  TO_CHAR(hiredate,'yymmdd') = '950901';\n<\/span><\/pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><\/div><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">'\ubc15\ubb38\uc218'\uc758 \uacbd\uc6b0\ub294 \uc2dc\uac04\uc744 \ubcc4\ub3c4\ub85c \uc9c0\uc815\ud558\uc9c0 \uc54a\uc558\uc73c\ubbc0\ub85c '00\uc2dc 00\ubd84 00\ucd08'\uac00 \uc800\uc7a5\ub418\uc5b4 \uc788\uc74c : '='\ub85c \ube44\uad50\ud558\ub354\ub77c\ub3c4 \uc6d0\ud558\ub294 \uacb0\uacfc\ub97c \uc5bb\uc74c<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">DATE \ud0c0\uc785\uc73c\ub85c \uc9c0\uc815\ub41c \uacbd\uc6b0\uc5d0\ub3c4 \ubc18\ub4dc\uc2dc \uc2dc\uac04\uc774 \ud544\uc694\ud558\uc9c0 \uc54a\ub2e4\uba74 SYSDATE\ub97c \uc785\ub825\ud558\uc9c0 \ub9d0\uace0 \ub0a0\uc9dc\ub9cc \uc785\ub825\uc2dc\ud0a4\ub294 \uac83\uc774 \ubc14\ub78c\uc9c1<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n\n<\/span><div class=\"preformatted panel\" style=\"border-width: 1px;\"><div class=\"preformattedContent panelContent\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">SELECT * FROM EMP WHERE HIREDATE LIKE '%95';\n<\/span><\/pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><\/div><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><div class=\"preformatted panel\" style=\"border-width: 1px;\"><div class=\"preformattedContent panelContent\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">SELECT * FROM EMP WHERE SUBSTR(HIREDATE,8,2) = '95';\n<\/span><\/pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><\/div><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><div class=\"preformatted panel\" style=\"border-width: 1px;\"><div class=\"preformattedContent panelContent\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">SELECT * FROM EMP WHERE to_char(HIREDATE,'YY') = '95';\n<\/span><\/pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><\/div><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">'SUBSTR' \ub4f1\uc758 \ud568\uc218\ub97c \uc774\uc6a9\ud558\uc5ec \uc2a4\ud2b8\ub9c1(String) \ube44\uad50\ub97c \ud558\ub294 \uacbd\uc6b0 : \ucee4\ub7fc\uac12\uc744 \ubcc0\ud654\uc2dc\ud0a4\uc9c0 \uc54a\uace0\ub294 \ucc98\ub9ac\ud560 \ubc29\ubc95\uc774 \uc5c6\ub2e4<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><\/td><\/tr><\/tbody><\/table><\/div><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">DATE \ud0c0\uc785\uc758 \uae30\ubcf8 \ud615\ud0dc\ub294 'DD-MON-YY' \ud615\uc2dd\n           <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uae30\ubcf8 \ud615\ud0dc\ub97c \ubc14\uafb8\uae30 \uc704\ud574\uc11c 'NLS_DATE_FORMAT'\uc744 \uc0ac\uc6a9\ud55c\ub2e4\uba74 \uc790\uc2e0\uc774 \uc6d0\ud558\ub294 \ud615\uc2dd\uc73c\ub85c \ubc14\uafc0 \uc218 \uc788\ub2e4 : \uc608) 'YYMMDD'\n                        <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ubcc4\ub3c4\uc758 \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uace0 'YYMMDD' \ud615\uc2dd\uc73c\ub85c \ub370\uc774\ud130\ub97c \uc785\ucd9c\ub825\ud560 \uc218 \uc788\uc73c\ub098, \ub0b4\ubd80\uc800\uc7a5\uc740 \ub9c8\ucc2c\uac00\uc9c0\ub85c \ub144\ub3c4(\uc138\uae30 \ud3ec\ud568), \uc6d4, \uc77c, \uc2dc, \ubd84, \ucd08\ub85c \uc800\uc7a5\ub418\ubbc0\ub85c \uadfc\ubcf8\uc801\uc778 \ubb38\uc81c\uac00 \ud574\uacb0\ub418\uc9c0\ub294 \uc54a\ub294\ub2e4<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n                 <\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n             <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ub0a0\uc9dc\ub97c \uc785\ub825\ud558\uc9c0 \uc54a\uace0 \uc2dc\uac04\ub9cc \uc785\ub825\ud55c\ub2e4\uba74? : \ub144\ub3c4(\uc138\uae30 \ud3ec\ud568), \uc6d4, \uc77c\uc740 \ub514\ud3f4\ub4dc \uac12\uc73c\ub85c \uc785\ub825\ub41c\ub2e4\n<\/span><div class=\"preformatted panel\" style=\"border-width: 1px;\"><div class=\"preformattedContent panelContent\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">SELECT TO_CHAR(TO_DATE('10:52:32','HH24:MI:SS'),'YY\/MM\/DD HH24:MI:SS')\nFROM   DUAL;\n<\/span><\/pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><\/div><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n                <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ud2b9\ubcc4\ud788 \ub0a0\uc9dc\ub97c \uc9c0\uc815\ud558\uc9c0 \uc54a\uc73c\uba74 \ud574\ub2f9 \uc6d4\uc758 \uccab\ub0a0(1\uc77c)\ub85c \uac04\uc8fc\ud55c\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uacb0\uacfc) \uc218\ud589\ud55c \ub0a0\uc9dc\uac00 95\ub144 9\uc6d4 25\uc77c\uc774\ub77c\uba74 \ucd9c\ub825 \uacb0\uacfc\ub294 '95\/09\/01 10:52:32'\uac00 \ub41c\ub2e4<br \/><br \/><br \/><\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n                <\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n     <\/span><\/li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">DATE \ud0c0\uc785 \ud65c\uc6a9\n    <\/span><ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ube48\ubc88\ud55c \ub0a0\uc9dc \uc5f0\uc0b0\uc774 \ud544\uc694\ud55c \uceec\ub7fc\n             <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc2dc\uac04\uc744 \uc800\uc7a5\ud560 \ud544\uc694\uac00 \uc5c6\uc744 \ub54c\ub294 \ubb38\uc790\ud0c0\uc785\uc744 \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \uc88b\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ubb38\uc790\ud0c0\uc785\uc758 \ub0a0\uc9dc\ud615\uc2dd(YYMMDD)\uc73c\ub85c \uc9c0\uc815\ud558\ub354\ub77c\ub3c4 \uc5f0\uc0b0\uc744 \ud558\ub294 \ub370\ub294 \ud070 \ubb38\uc81c\uac00 \uc5c6\ub2e4<\/span><\/li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">DATE \ud0c0\uc785\uc744 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub294 \uacbd\uc6b0\uc758 \ub0a0\uc9dc \uc5f0\uc0b0 \uc608\uc2dc\n                    <br \/><br \/><\/span><ol><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc218\uc8fc \ud14c\uc774\ube14(ORDERT)\uc5d0\uc11c DATE \ud0c0\uc785\uc73c\ub85c \uc9c0\uc815\ub41c \ud310\ub9e4\uc77c\uc790(SAL_DATE)\uac00 95\ub144 9\uc6d4\uc5d0 \ubc1c\uc0dd\ud55c \ub370\uc774\ud130\ub4e4\uc744\n \uc77d\uc5b4\uc11c \uc624\ub298\ubd80\ud130 10\uc77c\uc804 \uc0ac\uc774\uc5d0 \ud310\ub9e4\ub41c \ub9e4\ucd9c\uc218\ub7c9(SAL_QTY)\uc758 \ud569\uacfc \uc6d4\ub9d0\uc5d0 \ud310\ub9e4\ud55c \ub9e4\ucd9c\uc218\ub7c9\uc758 \ud569\uc744 \ubd80\uc11c(SAL_DEPT)\ubcc4\ub85c\n \uad6c\ud558\ub294 SQL\n<\/span><div class=\"preformatted panel\" style=\"border-width: 1px;\"><div class=\"preformattedContent panelContent\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">SELECT   sal_dept,\n         sum(decode(sign(10 - (sysdate - SAL_DATE)),1,sal_qty)),\n         sum(decode(SAL_DATE,last_day('01-SEP-95'),sal_qty))\nFROM     ordert\nWHERE    to_char(sal_date,'YYMM') = '9509'\nGROUP BY sal_dept;\n<\/span><\/pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><\/div><\/div><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ud310\ub9e4\uc77c\uc790\uc758 \ub370\uc774\ud130 \ud0c0\uc785\uc774 CHAR \ud0c0\uc785\uc778 \uacbd\uc6b0 : SAL_DATE \uceec\ub7fc\uc744 TO_DATE(SAL_DATE,'YYMMDD')\ub85c\ub9cc \ubc14\uafb8\uc5b4 \uc8fc\uba74 \ub3d9\uc77c\ud55c \uacb0\uacfc\ub97c \uc5bb\uc744 \uc218 \uc788\ub2e4\n<\/span><div class=\"preformatted panel\" style=\"border-width: 1px;\"><div class=\"preformattedContent panelContent\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">SELECT   sal_dept,\n         sum(decode(sign(10 - (sysdate - TO_DATE(SAL_DATE,'YYMMDD'))),1,sal_qty)),\n         sum(decode(TO_DATE(SAL_DATE,'YYMMDD'),last_day('01-SEP-95'),sal_qty))\nFROM     ordert\nWHERE    sal_date like '9509%'\nGROUP BY sal_dept;\n<\/span><\/pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><\/div><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n                           <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc7a5\uc810 : \ub3d9\uc77c\ud55c \uc5f0\uc0b0 \uae30\ub2a5\uc744 \uc218\ud589\ud558\uba74\uc11c \uc870\uac74\uc808\uc5d0\uc11c \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4<br \/><br \/><\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n                           <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">DATE \ud0c0\uc785\uc73c\ub85c \uc9c0\uc815\ub41c \uacbd\uc6b0\uc758 \uc778\ub371\uc2a4 \uc0ac\uc6a9 : BETWEEN \uc0ac\uc6a9\n<\/span><div class=\"preformatted panel\" style=\"border-width: 1px;\"><div class=\"preformattedContent panelContent\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">SELECT   sal_dept,\n         sum(decode(sign(10 - (sysdate - SAL_DATE)),1,sal_qty)),\n         sum(decode(SAL_DATE,last_day('01-SEP-95'),sal_qty))\nFROM     ordert\nWHERE    sal_date BETWEEN '01-SEP-95' AND LAST_DAY('01-SEP-95') + 0.99999\nGROUP BY sal_dept;\n<\/span><\/pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><\/div><\/div><\/li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc704 \ubc29\ubc95\uc73c\ub85c \ub3c4\uc800\ud788 \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud558\ub3c4\ub85d \ud560 \uc218 \uc5c6\ub294 \uacbd\uc6b0\n<\/span><div class=\"preformatted panel\" style=\"border-width: 1px;\"><div class=\"preformattedContent panelContent\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">SELECT *\nFROM   TAB1 a,\n       TAB2 b\nWHERE  a.COL1 = b.COL2\n       AND a.DAT1 = b.DAT2\n       AND a.FLD = 'ABC';\n<\/span><\/pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><\/div><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">DAT1\uacfc DAT2\ub294 \ubc1c\uc0dd\ud55c \uc2dc\uac04\uc774 \uc800\uc7a5\ub418\uc5b4 \uc788\ub2e4\uba74 \uc77c\uc790\ub294 \uac19\uc9c0\ub9cc \uc2dc\uac04\uc774 \uc11c\ub85c \ud2c0\ub9ac\ubbc0\ub85c \uc6d0\ud558\ub294 \uac12\uc744 \uc5bb\uc744 \uc218 \uc5c6\ub2e4<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\ub2e4\uc74c\uc758 SQL \uc0ac\uc6a9 : a.FLD \uc778\ub371\uc2a4\ub97c \uba3c\uc800 \uc561\uc138\uc2a4\ud558\ub294 'Nested Loop' \uc870\uc778\uc774 \uac00\uc7a5 \uc720\ub9ac\ud558\ub2e4\uace0 \uac00\uc815<\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><div class=\"preformatted panel\" style=\"border-width: 1px;\"><div class=\"preformattedContent panelContent\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">SELECT *\nFROM   TAB1 a,\n       TAB2 b\nWHERE  a.COL1 = b.COL2\n       AND TO_CHAR(a.DAT1,'YYMMDD') = TO_CHAR(b.DAT2,'YYMMDD')\n       AND a.FLD = 'ABC';\n<\/span><\/pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><\/div><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">DAT1\uacfc DAT2\uc758 \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uc73c\ubbc0\ub85c \uc218\ud589\uc18d\ub3c4\uac00 \ub9e4\uc6b0 \ub098\ube60\uc9c8 \uc218 \uc788\ub2e4<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\nBETWEEN\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud558\uac8c \ud560 \uc218\ub294 \uc788\ub2e4<\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><div class=\"preformatted panel\" style=\"border-width: 1px;\"><div class=\"preformattedContent panelContent\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">SELECT *\nFROM   TAB1 a,\n       TAB2 b\nWHERE  a.COL1 = b.COL2\n       AND b.DAT2 BETWEEN TRUNC(a.DAT1) AND TRUNC(a.DAT1) + 0.99999\n       AND a.FLD = 'ABC';\n<\/span><\/pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><\/div><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n                            <\/span><ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc8fc\uc758\ud560 \uc810\n                                  <br \/><br \/><\/span><ol><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">a.DAT1 BETWEEN TRUNC(b.DAT2) AND TRUNC(b.DAT2) + 0.99999 \ub85c \n\uc0ac\uc6a9\ud574\uc11c\ub294 \uc548\ub41c\ub2e4 : \ub4dc\ub77c\uc774\ube59 \ud14c\uc774\ube14\uc778 TAB1\uc758 FLD \uc778\ub371\uc2a4\ub97c \ud1b5\ud574 \ucc98\ub9ac\ubc94\uc704\uac00 \uacb0\uc815\ub418\uba70, a.COL1\uacfc a.DAT1\uc740 \ub2e8\uc9c0 \nb.COL2\uc640 b.DAT2\uc5d0\uac8c \uc0c1\uc218\uac12\uc744 \uc81c\uacf5\ud558\ub294 \uc5ed\ud560\ub9cc \ud558\uac8c \ub418\ubbc0\ub85c \ubcc0\ud615\uc774 \uc77c\uc5b4\ub098\ub3c4 \uc0c1\uad00 \uc5c6\uc9c0\ub9cc, DAT2\uc5d0 \ubcc0\ud615\uc774 \uc77c\uc5b4\ub098\uba74 \n\uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uac8c \ub41c\ub2e4<br \/><br \/><\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">TAB2\uc758 \uc778\ub371\uc2a4\uc758 \uc21c\uc11c\ub97c \ubc18\ub4dc\uc2dc 'COL2+DAT2'\ub85c \ud574\uc57c \ud55c\ub2e4 : 'DAT2+COL2'\ub85c \uacb0\ud569\uc778\ub371\uc2a4\uac00 \n\uc0dd\uc131\ub41c \uacbd\uc6b0 \uc120\ud589\uceec\ub7fc\uc778 DAT2\uac00 BETWEEN\uc73c\ub85c \uc0ac\uc6a9\ub418\uc5c8\uc73c\ubbc0\ub85c COL2\ub97c \ube44\ub85d '='\ub85c \uc0ac\uc6a9\ud558\uc600\ub354\ub77c\ub3c4 \ucc98\ub9ac\ubc94\uc704\ub97c \uc904\uc5ec\uc8fc\uc9c0 \n\ubabb\ud55c\ub2e4<br \/><br \/><\/span><\/li><\/ol><\/ul><\/ol><\/ul><\/ul><ul><ul><ol><ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n                                       <\/span><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uacb0\ud569\uc778\ub371\uc2a4\uc758 \ud65c\uc6a9\n                                  <br \/><br \/><\/span><ol><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc2dc\uac04\uc774 \ub4e4\uc5b4\uc788\ub294 DATE \uceec\ub7fc\uc740 \ub0a0\uc9dc\ub9cc \uc788\ub294 \uac83\uc5d0 \ube44\ud574 \ubcf4\ub2e4 \uc591\ud638\ud55c \ubd84\ud3ec\ub3c4\ub97c \uac00\uc9c0\ubbc0\ub85c DATE \uceec\ub7fc\uc774 \uc120\ud589\ud558\ub294 \n\uacb0\ud569\uc778\ub371\uc2a4\uac00 \ub354 \uc720\ub9ac\ud560 \uac83\uc73c\ub85c \uc0dd\uac01\ub418\uc9c0\ub9cc \uc2e4\uc81c\ub85c\ub294 \uadf8 \ubc18\ub300 : \ub300\ubd80\ubd84\uc758 \uacbd\uc6b0 \uc2dc\uac04\uc744 \uc870\uac74\uc5d0 \uae30\uc220\ud560 \uc218 \uc5c6\uc73c\ubbc0\ub85c 'LIKE'\ub098 \n'BETWEEN'\uc744 \uc0ac\uc6a9\ud560 \uc218 \ubc16\uc5d0 \uc5c6\uace0, \uc120\ud589\ud558\ub294 \uceec\ub7fc\uc774 '='\uc774 \uc544\ub2c8\uba74 \ub4a4\uc5d0 \uc788\ub294 \uceec\ub7fc\uc774 \uc544\ubb34\ub9ac '='\ub85c \uc0ac\uc6a9\ub418\uc5c8\ub354\ub77c\ub3c4 \uc774\ubbf8 \n\uc778\ub371\uc2a4\uc758 \ucc98\ub9ac\ubc94\uc704\ub294 \uc904\uc5b4\ub4e4\uc9c0 \uc54a\ub294\ub2e4<br \/><br \/><\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">DATE \ud0c0\uc785\uc744 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uace0 'YYMMDD' \ud615\uc2dd\uc758 \ubb38\uc790\ud0c0\uc785\uc744 \uc0ac\uc6a9\ud55c \uacbd\uc6b0\ub294 \ubaa8\ub4e0 \uceec\ub7fc\uc774 '='\ub85c \uc0ac\uc6a9\ub418\uc5c8\uc73c\ubbc0\ub85c \uc778\ub371\uc2a4 \ucc98\ub9ac\ubc94\uc704\ub294 \ucd5c\uc18c\ud55c\uc73c\ub85c \uc904\uc5b4\ub4e4\uac8c \ub41c\ub2e4<br \/><br \/><\/span><\/li><\/ol><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n                                      <\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n                             <\/span><\/ol><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n                  <\/span><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n          <\/span><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ubc18\ub4dc\uc2dc \uc778\ub371\uc2a4\ub97c \uc0dd\uc131\ud574\uc57c \ud558\uba70 'LIKE'\ub098 'BETWEEN' \ub4f1\uc73c\ub85c \uc790\uc8fc \uc0ac\uc6a9\ub418\uc9c0\ub9cc \ud2b9\uc815\ud55c \uacbd\uc6b0\uc5d0\ub294 \uc2dc\uac04\uae4c\uc9c0 \uad00\ub9ac\ud560 \n\ud544\uc694\uac00 \uc788\ub294 \uceec\ub7fc : 'YYMMDD' \ud615\uc2dd\uc758 \ubb38\uc790\ud0c0\uc785\uc73c\ub85c \uc9c0\uc815\ud558\ub418 \uc2dc\uac04\uc744 \uad00\ub9ac\ud558\uae30 \uc704\ud55c \uceec\ub7fc(NUMBER \ud0c0\uc785)\uc744 \ubcc4\ub3c4\ub85c \ucd94\uac00\ud558\ub294\n \uac83\uc774 \uc88b\ub2e4\n              <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">TO_CHAR \ud568\uc218\uc5d0\uc11c 'SSSSS'\ub294 \ud574\ub2f9 \uc77c\uc790\uc758 \uc2dc\uc791(00\uc2dc 00\ubd84 00\ucd08)\ubd80\ud130 \ud604\uc7ac\uae4c\uc9c0\ub97c \ucd08(Sec)\ub85c \ud658\uc0b0\ud55c \uac12 : DATE \ud0c0\uc785\uc744 \uc0ac\uc6a9\ud588\uc744 \ub54c\uc640 \ub3d9\uc77c\ud55c \uc2dc\uac04\uc744 \uc800\uc7a5\ud560 \uc218 \uc788\ub2e4\n<\/span><div class=\"preformatted panel\" style=\"border-width: 1px;\"><div class=\"preformattedContent panelContent\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">INSERT INTO table (col1, col2, ..., date_col, time_col)\nVALUES     (:var1, :var2, ..., '950925', TO_CHAR(SYSDATE,'SSSSS'));\n<\/span><\/pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><\/div><\/div><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc5b4\ub5a4 \uceec\ub7fc\uac04\uc758 \uc2dc\uac04 \ucc28\uc774\ub97c \ubd84(Minute)\uc73c\ub85c \ud658\uc0b0\ud558\ub294 \uc5f0\uc0b0\n<\/span><div class=\"preformatted panel\" style=\"border-width: 1px;\"><div class=\"preformattedContent panelContent\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">SELECT ((TO_DATE(\ucd9c\uace0\uc77c||\ucd9c\uace0\uc2dc\uac04,'YYMMDDSSSSS') - TO_DATE(\uc785\uace0\uc77c||\uc785\uace0\uc2dc\uac04,'YYMMDDSSSSS'))*24*60\nFROM ordert\nWHERE sal_date = '950925';\n<\/span><\/pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><\/div><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n                   <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ub0a0\uc9dc\uc640 \uc2dc\uac04\uc744 \uacb0\ud569\ud558\uc5ec 'YYMMDDSSSSS' \ud615\uc2dd\uc73c\ub85c \uc9c0\uc815\ud558\uc5ec TO_DATE \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec DATE \ud0c0\uc785\uc73c\ub85c \ubcc0\ud654\uc2dc\ud0a4\uba74 \uc644\ubcbd\ud55c '\ub144\uc6d4\uc77c\uc2dc\ubd84\ucd08' \ud615\uc2dd\uc758 DATE\ub85c \ubcc0\ud658\ub41c\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc2dc\uac04\uc744 \uc800\uc7a5\ud558\ub294 \uceec\ub7fc\uc5d0 'HH24MISS'\uc758 \ubc29\uc2dd\uc73c\ub85c \uc800\uc7a5\ud574\ub3c4 \ub3d9\uc77c\ud55c \ubc29\ubc95\uc73c\ub85c \ucc98\ub9ac \uac00\ub2a5<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n                     <\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n             <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc8fc\ub85c \ub0a0\uc9dc \uc5f0\uc0b0\uc5d0\ub9cc \uc0ac\uc6a9\ud558\uac70\ub098 \uc2dc\uac04\uc758 \uae30\ub85d(Logging)\uc774 \ud544\uc694\ud55c \uacbd\uc6b0 DATE \ud0c0\uc785 \uc0ac\uc6a9\n               <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc778\ub371\uc2a4\ub97c \uc0dd\uc131\ud560 \ud544\uc694\uac00 \uc788\ub2e4\uba74 'LIKE'\ub97c \uc4f0\uc9c0 \ub9d0\uac83(\uacb0\ud569\uc778\ub371\uc2a4\uc758 \uc120\ud589\uceec\ub7fc\uc774 \uc544\ub2cc \uacbd\uc6b0\uc5d0\ub294 \uac00\ub2a5\ud558\ub098 \uc778\ub371\uc2a4 \ucc98\ub9ac\ubc94\uc704\ub97c \uc904\uc774\ub294 \ub370 \uae30\uc5ec\ud558\uc9c0 \ubabb\ud55c\ub2e4)<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">'BETWEEN'\uc73c\ub85c \ubc14\uafb8\uc5b4 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uacbd\uc6b0 \uacb0\ud569\uc778\ub371\uc2a4\uc758 \ub4b7\ubd80\ubd84\uc5d0\uc11c\ub9cc \uc0ac\uc6a9\ub418\ub294 \uacbd\uc6b0 \ubb38\uc81c \ubc1c\uc0dd\ud558\uc9c0 \uc54a\ub294\ub2e4<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n         <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc2dc\uac04\uc740 \uc785\ub825\ub418\uc9c0 \uc54a\uace0 \ub0a0\uc9dc\ub9cc \uc785\ub825\ub418\ub294 \uacbd\uc6b0 DATE \ud0c0\uc785 \uc0ac\uc6a9 \uace0\ub824 \uac00\ub2a5\n            <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">'\ub144\uc6d4'\ub9cc \ube44\uad50\ud560 \ub54c \uc808\ub300 'LIKE'\ub97c \uc0ac\uc6a9\ud574\uc11c\ub294 \uc548\ub418\uba70 \ubc18\ub4dc\uc2dc 'BETWEEN'\uc744 \uc0ac\uc6a9\ud574\uc57c \ud55c\ub2e4 : 'LIKE'\uac00 \uc0ac\uc6a9\ub41c \ubaa8\ub4e0 DATE \ud0c0\uc785 \uceec\ub7fc\uc740 \ub0b4\ubd80\uc801\uc778 \ubcc0\ud615\uc774 \uc77c\uc5b4\ub098 \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc798\ubabb\ub41c \uc0ac\uc6a9 \uc608\n                       <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">'LIKE'\ub97c \uc0ac\uc6a9\ud588\uc73c\ubbc0\ub85c \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\ub2e4\n<\/span><div class=\"preformatted panel\" style=\"border-width: 1px;\"><div class=\"preformattedContent panelContent\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">SELECT empno, ename, job, deptno, sal\nFROM   emp\nWHERE  hiredate LIKE '%95';\n<\/span><\/pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><\/div><\/div><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">'NLS_DATE_FORMAT'\uc744 'YYMMDD' \ud615\uc2dd\uc73c\ub85c \ud558\ub354\ub77c\ub3c4 'LIKE'\ub97c \uc0ac\uc6a9\ud588\uc73c\ubbc0\ub85c \ub9c8\ucc2c\uac00\uc9c0\ub85c \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\ub2e4\n<\/span><div class=\"preformatted panel\" style=\"border-width: 1px;\"><div class=\"preformattedContent panelContent\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">SELECT empno, ename, job, deptno, sal\nFROM   emp\nWHERE  hiredate LIKE '95%';\n<\/span><\/pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><\/div><\/div><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">'LIKE'\ub97c 'BETWEEN'\uc73c\ub85c \ubc14\uafb8\uae30 \uc704\ud55c \ubc29\ubc95 : \uc778\ub371\uc2a4 \uc0ac\uc6a9\n<\/span><div class=\"preformatted panel\" style=\"border-width: 1px;\"><div class=\"preformattedContent panelContent\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">SELECT empno, ename, job, deptno, sal\nFROM   emp\nWHERE  hiredate BETWEEN '01-jan-95' AND TO_DATE('31-dec-95') + 0.99999;\n<\/span><\/pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><\/div><\/div><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n                  <\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n             <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ub2e4\ub978 \ud14c\uc774\ube14\uacfc \uc870\uc778\uc2dc\uc5d0 \uc5f0\uacb0\uace0\ub9ac\ub85c \uc0ac\uc6a9\ub418\ub294 \uceec\ub7fc\uc740 \ube44\uad50\ub418\ub294 \uc0c1\ub300\uceec\ub7fc\uacfc \ubc18\ub4dc\uc2dc \ub3d9\uc77c\ud55c \ub370\uc774\ud130 \ud0c0\uc785\uc774\uc5b4\uc57c \ud55c\ub2e4\n            <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">DATE \ud0c0\uc785\uc758 \ub0a0\uc9dc\uceec\ub7fc\uacfc \ubb38\uc790\ud0c0\uc785\uc758 \ub0a0\uc9dc\uceec\ub7fc\uc774 \ud63c\uc6a9\ub418\uc5b4 \uc788\ub294 \uacbd\uc6b0 \uc870\uc778\uc5d0\uc11c \ud55c\ucabd \uceec\ub7fc\uc5d0 \ubcc0\ud654\uac00 \uc77c\uc5b4\ub098\uc57c \ud558\ubbc0\ub85c '\uc5f0\uacb0\uace0\ub9ac \uc774\uc0c1' \uc0c1\ud0dc\uac00 \ubc1c\uc0dd<br \/><br \/><\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n         <\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n     <\/span><\/ol><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n\n<\/span><h4><a name=\"\uc81c3\uc7a5\ub370\uc774\ud130\ud0c0\uc785\ubc0f\uae38\uc774\uc758\uacb0\uc815-2.6LONG\ud0c0\uc785\"><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">2.6 LONG \ud0c0\uc785<\/span><\/h4><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n<\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc544\uc8fc \uae34 \ubb38\uc790\uc5f4\uc744 \uc800\uc7a5(\ucd5c\ub300 2\uae30\uac00\ubc14\uc774\ud2b8\uae4c\uc9c0 \uc800\uc7a5)<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">VARCHAR2 \ud0c0\uc785\uacfc \uac70\uc758 \ub3d9\uc77c\ud55c \ud2b9\uc9d5<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uba87 \uac00\uc9c0 \uc81c\ud55c\uc0ac\ud56d\ub4e4\uc774 \uc788\uc73c\ubbc0\ub85c \ucda9\ubd84\ud788 \uac80\ud1a0 \ud6c4 \uc0ac\uc6a9<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n\n<\/span><ol><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">LONG \ud0c0\uc785\uc758 \uc0ac\ub840\n      <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">'USERS_VIEWS' \uc870\ud68c\uc2dc 'TEXT' \uceec\ub7fc\uc774 LONG \ud0c0\uc785\n<\/span><div class=\"preformatted panel\" style=\"border-width: 1px;\"><div class=\"preformattedContent panelContent\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">SELECT TEXT\n  FROM USER_VIEWS\n WHERE VIEW_NAME = 'view_name';\n<\/span><\/pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><\/div><\/div><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">80\ubc14\uc774\ud2b8(\ub514\ud3f4\ud2b8) \uc774\uc0c1\uc744 \ucd9c\ub825\ud558\ub824\uba74\n<\/span><div class=\"preformatted panel\" style=\"border-width: 1px;\"><div class=\"preformattedContent panelContent\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">SQL&gt; SET LONG number\n<\/span><\/pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><\/div><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n                <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">number : 1 ~ 2,000,000,000\uae4c\uc9c0 \uc9c0\uc815 \uac00\ub2a5<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n              <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc0ac\uc6a9 \uac00\ub2a5\ud55c \uceec\ub7fc\n              <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc11c\ube0c\ucffc\ub9ac\uac00 \uc544\ub2cc SQL\uc758 SELECT list<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">UPDATE \ubb38\uc758 'SET'<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">INSERT \ubb38\uc758 'VALUES' \uad6c\uc5d0 \ub300\uc751\ub418\ub294 \uceec\ub7fc\uc5d0\uc11c \uc0ac\uc6a9 \uac00\ub2a5<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n           <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">LONG \ud0c0\uc785\uc758 \uc81c\ud55c\uc0ac\ud56d\n          <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ud558\ub098\uc758 \ud14c\uc774\ube14\uc5d0\ub294 \uc624\uc9c1 \ud558\ub098\uc758 LONG \ud0c0\uc785\ub9cc \ud5c8\uc6a9<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">(NOT) NULL\uc744 \uc81c\uc678\ud55c \ub2e4\ub978 \uc81c\uc57d\uc870\uac74(Constraint)\uc744 \uc9c0\uc815\ud560 \uc218 \uc5c6\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc870\uac74\uc808\uc5d0 \uc0ac\uc6a9\ub418\uc5b4 \ub2e4\ub978 \uac83\uacfc \ube44\uad50\ub420 \uc218 \uc5c6\ub2e4 : \ube44\uad50\uac00 \ud544\uc694\ud55c \uacbd\uc6b0\uc5d0\ub294 VARCHAR2 \ud0c0\uc785 \uc0ac\uc6a9(2000\ubc14\uc774\ud2b8\uae4c\uc9c0 \uc0ac\uc6a9 \uac00\ub2a5)<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc778\ub371\uc2a4\ub97c \ub9cc\ub4e4 \uc218 \uc5c6\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ud504\ub85c\uc2dc\uc838\ub098 \uc800\uc7a5\ud615 \ud568\uc218\uc5d0\uc11c \ubcc0\uc218\ub85c \ubc1b\uc744 \uc218 \uc5c6\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ub2e4\uc74c\uacfc \uac19\uc740 SQL\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\ub2e4\n<\/span><div class=\"preformatted panel\" style=\"border-width: 1px;\"><div class=\"preformattedContent panelContent\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">INSERT INTO table_name(...., long_type_column)\n  SELECT ...., long_type_column\n    FROM table_name\n   WHERE conditions ....;\n\nUPDATE table_name\n   SET long_type_column = (SELECT long_type_column\n                             FROM table_name\n                            WHERE conditions ....)\n WHERE conditions ....;\n\nCREATE TABLE table_name\n  AS SELECT ...., long_type_column\n       FROM table_name\n      WHERE conditions ....;\n<\/span><\/pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n<\/span><\/div><\/div><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">LONG \uceec\ub7fc\uc744 \ub2e4\ub978 \ud14c\uc774\ube14\ub85c \uc62e\uae30\uac70\ub098 \ub300\uccb4\uc2dc\ud0a4\uac70\ub098 \uc0c8\ub85c \uc0dd\uc131\ud558\uba74\uc11c \uc774\ub3d9\uc2dc\ud0ac \uc218\ub3c4 \uc5c6\ub2e4\n                   <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">SQL*PLUS\uc5d0\uc11c 'COPY' \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc0c8\ub85c\uc6b4 \ud14c\uc774\ube14\uc5d0 \uc774\ub3d9\ud558\uc5ec \uc0dd\uc131\uc2dc\ud0a4\uac70\ub098 \uae30\uc874\uc758 \ud14c\uc774\ube14\uc5d0 \ucd94\uac00 \uac00\ub2a5<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc791\uc5c5 \uc804\uc5d0 \ubc18\ub4dc\uc2dc 'SET LONG 2000000000' \uba85\ub839\uc744 \uc218\ud589\ud558\uc5ec LONG \uceec\ub7fc\uc758 I\/O \ud06c\uae30\ub97c \ub298\ub824\uc918\uc57c \ud55c\ub2e4<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n                  <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">SELECT\ubb38 \ub0b4\uc5d0\uc11c WHERE\uc758 \uc870\uac74, GROUP BY, ORDER BY, CONNECT BY, DISTINCT \ub4f1\uc758 \uac01\uc885 \ud568\uc218\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">SQL \ud568\uc218(substr, ...)\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc11c\ube0c\ucffc\ub9ac(Sub-Query) \ub9ac\uc2a4\ud2b8\ub85c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\ub2e4<br \/><br \/><\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n          <\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n     <\/span><\/li><\/ol><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n\n<\/span><h4><a name=\"\uc81c3\uc7a5\ub370\uc774\ud130\ud0c0\uc785\ubc0f\uae38\uc774\uc758\uacb0\uc815-2.7RAW,LONGRAW,ROWID\ud0c0\uc785\"><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">2.7 RAW, LONG RAW, ROWID \ud0c0\uc785<\/span><\/h4><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n<\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">RAW, LONG RAW \ud0c0\uc785\n <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ud5e5\uc0ac\ub370\uc2dc\uba40(Hexa Decimal) \ud615\ud0dc\ub85c \ub370\uc774\ud130\ub97c \uc800\uc7a5<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uadf8\ub798\ud53d, \uc774\ubbf8\uc9c0, \uc74c\uc131 \ub4f1\uc758 \uc815\ubcf4 \uad00\ub9ac(\uc8fc\ub85c \uc801\uc740 \uc0ac\uc774\uc988)\n             <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc0ac\uc774\uc988\uac00 \ud070 \uc774\ubbf8\uc9c0\ub098 \ub9ce\uc740 \uc591\uc758 \uc774\ubbf8\uc9c0\ub294 \uad11\ud30c\uc77c \ub4f1\uc744 \uc0ac\uc6a9<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc790\uc8fc \uc0ac\uc6a9\ub418\ub294 \ub370\uc774\ud130\ub294 \ud14c\uc774\ube14\uc5d0\uc11c \uad00\ub9ac\ud558\uace0 \uac00\ub054\uc529 \uc0ac\uc6a9\ud558\ub294 \ub370\uc774\ud130\ub294 \ub2e4\ub978 \uc7a5\uce58\ub97c \ud65c\uc6a9\ud558\ub294 \uac83\uc774 \uacbd\uc81c\uc801, \ud6a8\uacfc\uc801<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n          <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uae30\ubcf8\uc801\uc778 \uc81c\uc57d\uc0ac\ud56d\n             <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">RAW : VARCHAR2\uc640 \uc720\uc0ac<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">LONG RAW : LONG \ud0c0\uc785\uacfc \uc720\uc0ac<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc218\uc815 \ubd88\uac00\ub2a5(\uc800\uc7a5, \ucd94\ucd9c\ub9cc \uac00\ub2a5)<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n                <\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n     <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">ROWID \ud0c0\uc785\n    <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">DBMS\uc758 \ub85c\uc6b0\uc815\ubcf4\ub97c \uad00\ub9ac\ud558\uae30 \uc704\ud55c \ub370\uc774\ud130 \ud0c0\uc785<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc2e4\uc81c\ub85c\ub294 \uc778\ub371\uc2a4\uc5d0\ub9cc ROWID\uac00 \uc874\uc7ac(\ub85c\uc6b0\uac00 \uc874\uc7ac\ud558\ub294 \ud14c\uc774\ube14\uc5d0\ub294 \uc5c6\ub2e4)<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">SQL\ub85c \ucd94\ucd9c\ud560 \ub54c\ub294 18\ubc14\uc774\ud2b8\ub85c \ucd9c\ub825(\uc2e4\uc81c\ub85c\ub294 6\ubc14\uc774\ud2b8\ub85c \uc800\uc7a5\ub41c\ub2e4)<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ubcc0\uc218\uc5d0 \uc800\uc7a5\ud558\uace0\uc790 \ud560\ub54c\n               <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">PL\/SQL\uc5d0\uc11c\ub294 ROWID \ud0c0\uc785\uc744 \uc9c0\uc815 \uac00\ub2a5(\uadf8 \uc678\uc5d0\ub294 18\uc790\ub9ac \ubb38\uc790\ud0c0\uc785\uc73c\ub85c \uc9c0\uc815\ud574\uc57c \ud55c\ub2e4)<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n              <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ud074\ub7ec\uc2a4\ud130\ub9c1 \ub418\uc5b4 \uc788\uc9c0 \uc54a\uc740 \ud14c\uc774\ube14\uc5d0 \ub300\ud574\uc11c\ub294 \ud56d\uc2dc \uc720\uc77c\ud55c ROWID\ub97c \uac16\ub294\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uba40\ud2f0 \ud14c\uc774\ube14\ub85c \ud074\ub7ec\uc2a4\ud130\ub9c1\ub41c \ud14c\uc774\ube14\uc5d0\uc11c \uac19\uc740 ROWID\ub97c \uac00\uc9c4 \uc11c\ub85c \ub2e4\ub978 \ud14c\uc774\ube14\uc758 \ub85c\uc6b0\uac00 \uc874\uc7ac<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ub85c\uc6b0\uac00 Export, Import \ub418\uc9c0 \uc54a\ub294 \ud55c \ubcc0\ub3d9\ub418\uc9c0 \uc54a\ub294\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ub85c\uc6b0 \uc785\ub825\uc2dc ROWID\ub97c \uc0ac\uc6a9\uc790\uac00 \uc9c0\uc815\ud560 \uc218 \uc5c6\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc778\ub371\uc2a4\uc758 \uad6c\uc131\uc694\uc18c\uac00 \ub41c\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">SELECT\ubb38\uc5d0\uc11c ROWID\ub97c \uc694\uad6c\ud558\uc5ec \ucd9c\ub825\ud560 \uc218 \uc788\ub2e4<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n        <\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n\n<\/span><h4><a name=\"\uc81c3\uc7a5\ub370\uc774\ud130\ud0c0\uc785\ubc0f\uae38\uc774\uc758\uacb0\uc815-2.8LOB\ud0c0\uc785\"><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">2.8 LOB \ud0c0\uc785<\/span><\/h4><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n<\/span><h4><a name=\"\uc81c3\uc7a5\ub370\uc774\ud130\ud0c0\uc785\ubc0f\uae38\uc774\uc758\uacb0\uc815-2.9XML\ud0c0\uc785\"><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">2.9 XML \ud0c0\uc785<\/span><\/h4><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n<\/span><h3><a name=\"\uc81c3\uc7a5\ub370\uc774\ud130\ud0c0\uc785\ubc0f\uae38\uc774\uc758\uacb0\uc815-3.\ub370\uc774\ud130\uae38\uc774\uc758\uacb0\uc815\"><\/a><ins><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">3. \ub370\uc774\ud130 \uae38\uc774\uc758 \uacb0\uc815<\/span><\/ins><\/h3><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n<\/span><h4><a name=\"\uc81c3\uc7a5\ub370\uc774\ud130\ud0c0\uc785\ubc0f\uae38\uc774\uc758\uacb0\uc815-3.1VARCHAR\ud0c0\uc785\uc758\uae38\uc774\uacb0\uc815\"><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">3.1 VARCHAR \ud0c0\uc785\uc758 \uae38\uc774 \uacb0\uc815<\/span><\/h4><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n<\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uac00\ub2a5\ud55c \ucda9\ubd84\ud788 \ucd5c\ub300\uce58\ub97c \ubd80\uc5ec\ud558\ub294 \uac83\uc774 \ud6a8\uacfc\uc801\n   <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc2e4\uc81c \uc785\ub825\ub41c \uae38\uc774\ub9cc \uc800\uc7a5\ub41c\ub2e4 : \uacf5\uac04\uc774\uc6a9 \uce21\uba74\uc5d0\uc11c \ubd88\uc774\uc775\uc774 \uc804\ud600 \uc5c6\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc9c0\uc815\ub41c \uae38\uc774\ub294 \uccb4\ud06c(Check) \uae30\ub2a5\ub9cc \ud560 \ubfd0\uc774\ub2e4 : \uc77c\uc815 \uae38\uc774 \uc774\uc0c1\uc778 \ub370\uc774\ud130\uc758 \uc785\ub825\uc744 \uc81c\ud55c\ud558\uace0\uc790 \ud560 \ub54c<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc9c0\ub098\uce58\uac8c \ud070 \uacbd\uc6b0\uc5d0\ub294 \ubd88\ud3b8\uc744 \ucd08\ub798\ud558\uae30\ub3c4 \ud55c\ub2e4 : SQL*Forms \uc5d0\uc11c\ub294 \ud654\uba74 \uceec\ub7fc\uc758 \uae38\uc774 \uc870\uc815 \ud544\uc694<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n     <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">IBM\uc758 \uacbd\uc6b0 : \ud55c\uae00\uc774 \uc800\uc7a5\ub420 \ub54c 'SO', 'SI'\uac00 \uac19\uc774 \uc800\uc7a5\ub418\ub294 \uacbd\uc6b0\uc5d0 \ub208\uc5d0 \ubcf4\uc774\uc9c0 \uc54a\ub294 \uac12\uc744 \uc704\ud574 \uc5ec\uc720\uc788\ub294 \uae38\uc774 \uc9c0\uc815 \ud544\uc694<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n\n<\/span><h4><a name=\"\uc81c3\uc7a5\ub370\uc774\ud130\ud0c0\uc785\ubc0f\uae38\uc774\uc758\uacb0\uc815-3.2CHAR\ud0c0\uc785\uc758\uae38\uc774\uacb0\uc815\"><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">3.2 CHAR \ud0c0\uc785\uc758 \uae38\uc774 \uacb0\uc815<\/span><\/h4><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n<\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uac00\ub2a5\ud55c \ucd5c\uc18c \uae38\uc774\ub85c \uc9c0\uc815\ud574\uc57c \ud55c\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ucda9\ubd84\ud788 \ud06c\uae30\ub97c \uc608\uc0c1\ud560 \uc218 \uc788\ub294 \uceec\ub7fc\uc5d0\ub9cc \uc9c0\uc815(\uc0ac\ubc88, \ubd80\uc11c\ucf54\ub4dc \ub4f1)<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uae38\uc774\uac00 \uae34 \uacbd\uc6b0\ub294 \ubc18\ub4dc\uc2dc VARCHAR2 \uc0ac\uc6a9<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uceec\ub7fc \uae38\uc774\uac00 \ud55c\uc790\ub9ac\uc778 \uacbd\uc6b0\ub294 \ubc18\ub4dc\uc2dc CHAR \uc0ac\uc6a9(\uae38\uc774 \uc9c0\uc815\ud558\uc9c0 \uc54a\uc544\ub3c4 \ub41c\ub2e4)<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n\n<\/span><h4><a name=\"\uc81c3\uc7a5\ub370\uc774\ud130\ud0c0\uc785\ubc0f\uae38\uc774\uc758\uacb0\uc815-3.3NUMBER\ud0c0\uc785\uc758\uae38\uc774\uacb0\uc815\"><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">3.3 NUMBER \ud0c0\uc785\uc758 \uae38\uc774 \uacb0\uc815<\/span><\/h4><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n<\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uac00\ub2a5\ud55c \ud06c\uac8c \uc9c0\uc815\ud558\ub294 \uac83\uc774 \uc88b\ub2e4\n     <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc9c0\uc815\ud55c \uceec\ub7fc \uae38\uc774\uc5d0 \uad00\uacc4 \uc5c6\uc774 \ubb34\uc870\uac74 \uac00\ubcc0\uae38\uc774\ub85c \uc800\uc7a5\ub428<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">Application\uc5d0\uc11c \uc0ac\uc6a9\ub420 \ubc94\uc704\uc758 \ucd5c\ub300\uac12\uc5d0 \ub9de\ucd94\uc5b4 \uacb0\uc815 : \uccb4\ud06c \uae30\ub2a5\uc73c\ub85c \uc0ac\uc6a9<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n  <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uad73\uc774 \uae38\uc774\ub97c \uc81c\ud55c\ud558\uc9c0 \uc54a\ub294 \uacbd\uc6b0\uc5d0\ub294 \uae38\uc774\ub97c \ud45c\uc2dc\ud558\uc9c0 \uc54a\uace0 'NUMBER'\ub85c\ub9cc \uc9c0\uc815 \uac00\ub2a5<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc18c\uc218\uc810 \uc774\ud558\ub294 \ubc18\uc62c\ub9bc\ub418\uc5b4 \uc800\uc7a5\ub418\ubbc0\ub85c \uad00\ub9ac\ud558\uace0\uc790 \ud558\ub294 \uc815\ud655\ud55c \uc18c\uc218\uc810 \uc790\ub9ac\uc218\ub97c \uc9c0\uc815\n       <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ucc38\uace0) NUMBER(P,S)\ub85c \uc9c0\uc815\ud560 \ub54c P\ub294 \uc815\uc218\ubd80\ubd84\uacfc \uc18c\uc218\uc810\uae4c\uc9c0 \ud3ec\ud568\ub41c \uc804\uccb4 \ub370\uc774\ud130\uc758 \ud06c\uae30\ub97c \uc758\ubbf8\ud558\ubbc0\ub85c \uc8fc\uc758 \ud544\uc694<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n      <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc624\ub77c\ud074\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 \ub370\uc774\ud130 \ud0c0\uc785 \ubcc0\ud658 \ud568\uc218\n     <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc6d0\ud558\ub294 \ud615\ud0dc\uc758 \ub370\uc774\ud130 \ud0c0\uc785\uc73c\ub85c \ubcc0\uacbd<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc5f0\uc0b0\uc774\ub098 \ube44\uad50\uac00 \uc218\ud589\ub420 \ub54c \ud544\uc694\uc5d0 \ub530\ub77c \uc790\ub3d9\uc73c\ub85c \ubcc0\ud658\uc774 \uc774\ub8e8\uc5b4\uc9d0 : \uaddc\uce59\uc744 \uc219\uc9c0\ud558\uc5ec \uceec\ub7fc\uc758 \ud0c0\uc785 \ubc0f \uae38\uc774\ub97c \uacb0\uc815<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">TO_NUMBER(), TO_CHAR(), TO_DATE(), HEXTORAW(), RAWTOHEX(), ROWIDTOCHAR(), CHARTOROWID() \ub4f1\ub4f1<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n     <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ub3c4\uba54\uc778(Domain)\uc758 \ud65c\uc6a9\n <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uac19\uac70\ub098 \uc720\uc0ac\ud55c \uc18d\uc131\uc744 \uac00\uc9c0\ub294 \uceec\ub7fc\ub4e4\uc740 \ub3d9\uc77c\ud55c \ub3c4\uba54\uc778\uc744 \uac16\ub3c4\ub85d \ud55c\ub2e4<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ud5a5\ud6c4\uc5d0 \uc608\uae30\uce58 \ubabb\ud55c \ubb38\uc81c \ubc1c\uc0dd\uc744 \ubbf8\uc5f0\uc5d0 \ubc29\uc9c0<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ubcc0\ud654\uc5d0 \ub2a5\ub3d9\uc801\uc73c\ub85c \ub300\ucc98 \uc6a9\uc774<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc77c\uad00\uc131\uc758 \uce21\uba74\uc744 \ucda9\ubd84\ud788 \uace0\ub824\ud558\ub294 \uc790\uc138 \ud544\uc694\n     <\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc2dc\uc2a4\ud15c \uc124\uacc4 \uac1c\ubc1c \uc804\uacfc\uc815\uc5d0\uc11c \ud544\uc694<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc2dc\uc2a4\ud15c\uc758 \ud488\uc9c8 \ud5a5\uc0c1, \ube44\uc6a9 \uc808\uc57d\ud558\ub294 \uae30\ubc18<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n        <\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n\n<\/span><h3><a name=\"\uc81c3\uc7a5\ub370\uc774\ud130\ud0c0\uc785\ubc0f\uae38\uc774\uc758\uacb0\uc815-4.\ucc38\uace0\uc815\ubcf4\"><\/a><ins><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">4. \ucc38\uace0\uc815\ubcf4<\/span><\/ins><\/h3><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n<\/span><h4><a name=\"\uc81c3\uc7a5\ub370\uc774\ud130\ud0c0\uc785\ubc0f\uae38\uc774\uc758\uacb0\uc815-4.1OracleBuiltinDatatypes\"><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">4.1 Oracle Built-in Datatypes<\/span><\/h4><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n<\/span><table class=\"confluenceTable\"><tbody>\n<tr>\n<th class=\"confluenceTh\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> Code <\/span><\/th>\n<th class=\"confluenceTh\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> Datatype <\/span><\/th>\n<th class=\"confluenceTh\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> 9i <\/span><\/th>\n<th class=\"confluenceTh\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> 10g <\/span><\/th>\n<th class=\"confluenceTh\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> 11g <\/span><\/th>\n<\/tr>\n<tr>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> 1 <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> VARCHAR2(size [BYTE | CHAR]) <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<\/tr>\n<tr>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> 1 <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> NVARCHAR2(size) <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<\/tr>\n<tr>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> 2 <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> NUMBER [ (p [, s]) ] <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<\/tr>\n<tr>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> 2 <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> FLOAT [(p)] <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> - <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> - <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<\/tr>\n<tr>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> 8 <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> LONG <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<\/tr>\n<tr>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> 12 <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> DATE <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<\/tr>\n<tr>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> 21 <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> BINARY_FLOAT <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> - <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<\/tr>\n<tr>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> 22 <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> BINARY_DOUBLE <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> - <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<\/tr>\n<tr>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> 180 <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> TIMESTAMP [(fractional_seconds_precision)] <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<\/tr>\n<tr>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> 181 <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> TIMESTAMP [(fractional_seconds)] WITH TIME ZONE <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<\/tr>\n<tr>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> 231 <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> TIMESTAMP [(fractional_seconds)] WITH LOCAL TIME ZONE <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<\/tr>\n<tr>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> 182 <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> INTERVAL YEAR [(year_precision)] TO MONTH <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<\/tr>\n<tr>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> 183 <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> INTERVAL DAY [(day_precision)] TO SECOND [(fractional_seconds)] <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<\/tr>\n<tr>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> 23 <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> RAW(size) <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<\/tr>\n<tr>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> 24 <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> LONG RAW <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<\/tr>\n<tr>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> 69 <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> ROWID <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<\/tr>\n<tr>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> 208 <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> UROWID [(size)] <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<\/tr>\n<tr>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> 96 <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> CHAR [(size [BYTE | CHAR])] <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<\/tr>\n<tr>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> 96 <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> NCHAR[(size)] <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<\/tr>\n<tr>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> 112 <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> CLOB <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<\/tr>\n<tr>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> 112 <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> NCLOB <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<\/tr>\n<tr>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> 113 <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> BLOB <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<\/tr>\n<tr>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> 114 <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> BFILE <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<td class=\"confluenceTd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \u25cb <\/span><\/td>\n<\/tr>\n<\/tbody><\/table><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n<\/span><h4><a name=\"\uc81c3\uc7a5\ub370\uc774\ud130\ud0c0\uc785\ubc0f\uae38\uc774\uc758\uacb0\uc815-4.2\uc624\ub77c\ud074DB2\ub370\uc774\ud130\ud0c0\uc785\ube44\uad50\"><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">4.2 \uc624\ub77c\ud074 DB2 \ub370\uc774\ud130\ud0c0\uc785 \ube44\uad50<\/span><\/h4><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n<\/span><p><br \/><\/p><p style=\"text-align: left; clear: none; float: none;\"><img decoding=\"async\" editor_component=\"image_link\" src=\"\/blog\/wp-content\/uploads\/cms_xe\/img0624.png\" alt=\"\" \/><\/p><p><br \/><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n\n<\/span><h3><br \/><\/h3><h3><a name=\"\uc81c3\uc7a5\ub370\uc774\ud130\ud0c0\uc785\ubc0f\uae38\uc774\uc758\uacb0\uc815-5.\ubb38\uc11c\uc5d0\ub300\ud558\uc5ec\"><\/a><ins><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">5. \ubb38\uc11c\uc5d0 \ub300\ud558\uc5ec<\/span><\/ins><\/h3><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\n\n<\/span><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ucd5c\ucd08\uc791\uc131\uc790 : <\/span><a href=\"http:\/\/wiki.gurubee.net\/pages\/viewpage.action?pageId=688153\" title=\"\uae40\uc6d0\uc2dd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uae40\uc6d0\uc2dd<\/span><\/a><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\ucd5c\ucd08\uc791\uc131\uc77c : 2009\ub144 2\uc6d4 7\uc77c<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc774 \ubb38\uc11c\ub294 <\/span><a href=\"http:\/\/www.gurubee.net\" rel=\"nofollow\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc624\ub77c\ud074\ud074\ub7fd<\/span><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> <\/span><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\" class=\"error\">[\ub300\uc6a9\ub7c9 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2a4\ud130\ub514]<\/span><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\"> \ubaa8\uc784\uc5d0\uc11c \uc791\uc131\ud558\uc600\uc2b5\ub2c8\ub2e4.<\/span><\/li><li><font color=\"red\"><b><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 9pt;\">\uc774 \ubb38\uc11c\uc758 \ub0b4\uc6a9\uc740 \uc774\ud654\uc2dd\ub2d8\uc758 \ub300\uc6a9\ub7c9 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc194\ub8e8\uc1581 \uc744 \ucc38\uace0\ud588\uc2b5\ub2c8\ub2e4.<\/span><\/b><\/font><\/li><\/ul><p><br \/><\/p><p>\ubc1c\ucdcc : <a class=\"tx-link\" target=\"_blank\" href=\"http:\/\/wiki.gurubee.net\/pages\/viewpage.action?pageId=688175\" rel=\"noopener\">http:\/\/wiki.gurubee.net\/pages\/viewpage.action?pageId=688175<\/a><br \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>0. \ub370\uc774\ud130 \ud0c0\uc785 \ubc0f \uae38\uc774\uc758 \uc911\uc694\uc131 \uac01 \ub370\uc774\ud130 \ud0c0\uc785\uc758 \uace0\uc720\ud55c \ud2b9\uc131\uc774 \uc788\ub2e4 -&gt; \uceec\ub7fc \uc18d\uc131\uc5d0 \ub9de\ub294 \ub370\uc774\ud130 \ud0c0\uc785\uc744 \uc0ac\uc6a9\ud588\ub290\ub0d0 \uc5ec\ubd80\uc5d0 \ub530\ub77c\uc11c \ub9ce\uc740 \ucc28\uc774\uac00 \ubc1c\uc0dd \uc801\uc808\ud558\uc9c0 \ubabb\ud55c \ub370\uc774\ud130 \ud0c0\uc785 \uc120\uc815 -&gt; \uc218\ud589\uc18d\ub3c4 \uc800\ud558, \ubd88\ud544\uc694\ud55c \uc790\uc6d0\uc758 \ub0ad\ube44 \ucd08\ub798 \uac01 \ub370\uc774\ud130 \ud0c0\uc785\uc758 \ud2b9\uc131\uc5d0 \ub530\ub77c \uc815\ubcf4\ub97c \uac00\uc7a5 \ud6a8\uc728\uc801\uc73c\ub85c \ucc98\ub9ac\ud558\uae30 \uc704\ud55c \uc801\uc808\ud55c \ub370\uc774\ud130 \ud0c0\uc785\uc744 \uc120\uc815\ud574\uc57c \ud55c\ub2e4 CHAR, VARCHAR, NUMBER, DATE, [&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-512","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\/512","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=512"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/512\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=512"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=512"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=512"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}