[Oracle] Alter Table

ALTER TABLE t ADD (a VARCHAR2(1) default 'N');
ALTER TABLE t MODIFY (a VARCHAR2(1) default 'N');
ALTER TABLE t DROP a;

 

[출처] https://majesty76.tistory.com/27

저작자표시비영리

'공부' 카테고리의 다른 글

[Nginx] 405 Not Allowed  (0)	2020.01.18
[Algorithm] Swap by 3 XOR  (0)	2020.01.18
[Oracle] Alter Table  (0)	2020.01.18
[Oracle] Update & Delete by Join Table  (0)	2020.01.18
[Spring] @Async & @AOP  (0)	2020.01.18
[HDFS] Export & Import  (0)	2020.01.18