Ä®·³ Ãß°¡/º¯°æ ¹æ¹ý >>
ÀÌ·¸°Ô Çѹø ÇØ º¸¾Ò½À´Ï´Ù. [0] table »ý¼º SQL> create table col_add_tbl ( first_col varchar2(30)); SQL > desc col_add_tbl [1] column Ãß°¡ SQL> alter table col_add_tbl ADD ( second_col char(20)); SQL > desc col_add_tbl [2] MODIFY´Â tableÀÇ columnÀÇ Datatype, size, default °ªÀ» º¯°æÇÒ¶§ »ç¿ëÇÕ´Ï´Ù. À̶§ ÁÖÀÇ »çÇ×ÀÌ ¸¹À½... °á·ÐÀûÀ¸·Î.. Á÷Á¢ÀûÀ¸·Î columnÀÇ À̸§º¯°æÀº ºÒ°¡´É. ÇÏÁö¸¸,, subquery¸¦ ÅëÇÑ table»ý¼º½Ã alias¸¦ ÀÌ¿ëÇÏ¿© º¯°æ °¡´É SQL> alter table col_add_tbl MODIFY (second_col varchar2(20)); SQL > desc col_add_tbl Âü°í url http://database.sarang.net/?inc=read&aid=8406&criteria=oracle&subcrit=qna&record_idx=45&currpg=2 insert¹®ÀÇ subquery¸¦ ÀÌ¿ëÇؼ...? [3] column »èÁ¦ <-- oracle 8i new feature SQL> alter table col_add_tbl DROP COLUMN second_col ; SQL> desc col_add_tbl