{"id":37429,"date":"2026-04-15T09:00:20","date_gmt":"2026-04-15T00:00:20","guid":{"rendered":"https:\/\/blog.agentsoft.co.kr\/index.php\/2026\/04\/15\/37429\/"},"modified":"2026-04-15T09:00:20","modified_gmt":"2026-04-15T00:00:20","slug":"%ea%b1%b4%ea%b5%ad%eb%8c%80%ed%95%99%ea%b5%90-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4-%ec%8b%9c%ed%97%98%ec%a0%95%eb%a6%ac","status":"publish","type":"post","link":"https:\/\/blog.agentsoft.co.kr\/index.php\/2026\/04\/15\/37429\/","title":{"rendered":"[\uac74\uad6d\ub300\ud559\uad50] \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2dc\ud5d8\uc815\ub9ac"},"content":{"rendered":"

<\/p>\n

\ubaa9\ucc28<\/strong><\/p>\n

\uc5c6\uc74c<\/p>\n

\ubcf8\ubb38\ub0b4\uc6a9<\/strong><\/p>\n

4.5.2 \uae30\ubcf8 \uac12
\n– \ud14c\uc774\ube14 \uc0dd\uc131 \uc2dc default \uac12 \uc0dd\uc131
\nEx)
\nCreate table student
\n(tot_cred \tnumeric (3,0) default 0,
\nPrimary key(ID));
\nDefault 0 \uc73c\ub85c \ud574\uc8fc\uba74 \uadf8 \uc560\ud2b8\ub9ac\ubdf0\ud2b8\uc5d0 null\uac12\uc774 \uc548\ub4e4\uc5b4\uac00\uac8c \ud574\uc90c<\/p>\n

4.5.3 \uc778\ub371\uc2a4 \uc0dd\uc131
\n– \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2dc\uc2a4\ud15c\uc774 \ub9b4\ub808\uc774\uc158\uc758 \ubaa8\ub4e0 \ud22c\ud50c\uc744 \uc0b4\ud3b4\ubcf4\ub294 \uacfc\uc815 \uc5c6\uc774 \ud6a8\uacfc\uc801\uc73c\ub85c \ucc3e\uc744 \uc218 \uc788\ub294 \uc790\ub8cc\uad6c\uc870.
\nCreate index \uc778\ub371\uc2a4\uc774\ub984 on \ub9b4\ub808\uc774\uc158(\uc560\ud2b8\ub9ac\ubdf0\ud2b8)
\nCreate index studentID_index on student(ID);<\/p>\n

4.5.4 \ub300\ud615 \uac1d\uccb4 \ud0c0\uc785
\n– \ub300\ud615 \ub370\uc774\ud130 \uc800\uc7a5 \uac00\ub2a5
\nLob = large object
\nBook_review clob(10KB)
\nImage blob(10MB)
\nMovie blob(2GB)<\/p>\n

4.5.6 Create Table \ud655\uc7a5
\n\ud604\uc7ac \uc874\uc7ac\ud558\ub294 \ud14c\uc774\ube14\uacfc \uac19\uc740 \uc2a4\ud0a4\ub9c8\ub97c \uac00\uc9c0\uace0 \uc788\ub294 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud558\ub294 \uae30\ub2a5.
\nCreate table temp_instructor like instructor
\nCreate table \uc0c8\ub85c\uc6b4 \ud14c\uc774\ube14\uc774\ub984 like \uae30\uc874 \ud14c\uc774\ube14\uba85
\n– \uc9c8\uc758 \uacb0\uacfc\ub97c \ud3ec\ud568\ud558\ub294 \ud14c\uc774\ube14 \uc0dd\uc131
\nCreate table t1 as
\n(select *
\nfrom instructor
\nwhere dept_name = \u2018Music\u2019)
\nWith data(\uc624\ub77c\ud074\uc740 \uc774\uac70 \uc5c6\uc5b4\ub3c4 \ub428.)<\/p>\n

4.6 \uad8c\ud55c(Previlige)
\n\uacc4\uc815\uc73c\ub85c \uc778\uc99d(Authentication) -> \uad8c\ud55c\ubd80\uc5ec(Authorization)-\uc0ac\uc6a9\uc790\uac00 \uc5b4\ub514\uae4c\uc9c0 \ubb34\uc5c7\uc744 \ud560 \uc218 \uc788\ub294\uc9c0 \uad8c\ud55c \ubd80\uc5ec.
\n\uc778\uc99d\uc740 \ubcf4\uc548\uc774 \uc798 \ub418\uc5b4 \uc788\ub294\ub370, \uad8c\ud55c \ubd80\uc5ec\uc5d0\uc11c \uc798\ubabb\ub418\uba74 \ud53c\ud574\uac00 \ud06c\ub2e4. \ub0b4\ubd80\uc801\uc73c\ub85c \ub370\uc774\ud130\ub97c \ub9c8\uc74c\ub300\ub85c \uc5bb\uc744 \uc218 \uc788\uae30 \ub54c\ubb38.
\n\uad8c\ud55c\uc758 \uc885\ub958
\n–\t\ub370\uc774\ud130\ub97c \uc77d\uc744 \uad8c\ud55c(read)
\n–\t\uc0c8\ub85c\uc6b4 \ub370\uc774\ud130\ub97c \uc0bd\uc785\ud558\ub294 \uad8c\ud55c(Insert)
\n–\t\ub370\uc774\ud130\ub97c \uac31\uc2e0\ud558\ub294 \uad8c\ud55c(Update)
\n–\t\ub370\uc774\ud130\ub97c \uc0ad\uc81c\ud558\ub294 \uad8c\ud55c(Delete)<\/p>\n

\ucd9c\ucc98 : \ud574\ud53c\ucea0\ud37c\uc2a4<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

\ubaa9\ucc28 \uc5c6\uc74c \ubcf8\ubb38\ub0b4\uc6a9 4.5.2 \uae30\ubcf8 \uac12 – \ud14c\uc774\ube14 \uc0dd\uc131 \uc2dc default \uac12 \uc0dd\uc131 Ex) Create table student (tot_cred numeric (3,0) default 0, Primary key(ID)); Default 0 \uc73c\ub85c \ud574\uc8fc\uba74 \uadf8 \uc560\ud2b8\ub9ac\ubdf0\ud2b8\uc5d0 null\uac12\uc774 \uc548\ub4e4\uc5b4\uac00\uac8c \ud574\uc90c 4.5.3 \uc778\ub371\uc2a4 \uc0dd\uc131 – \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2dc\uc2a4\ud15c\uc774 \ub9b4\ub808\uc774\uc158\uc758 \ubaa8\ub4e0 \ud22c\ud50c\uc744 \uc0b4\ud3b4\ubcf4\ub294 \uacfc\uc815 \uc5c6\uc774 \ud6a8\uacfc\uc801\uc73c\ub85c \ucc3e\uc744 \uc218 \uc788\ub294 \uc790\ub8cc\uad6c\uc870. Create index \uc778\ub371\uc2a4\uc774\ub984 on \ub9b4\ub808\uc774\uc158(\uc560\ud2b8\ub9ac\ubdf0\ud2b8) […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[13813,545,46801],"class_list":["post-37429","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-13813","tag-545","tag-46801"],"_links":{"self":[{"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/posts\/37429","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/comments?post=37429"}],"version-history":[{"count":0,"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/posts\/37429\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/media?parent=37429"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/categories?post=37429"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/tags?post=37429"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}