22 05 2017

Oracle DDL문 생성및관리

http://cafe.naver.com/ocmkorea/book5085531/17192

테이블 수정

#>su - oracle
$>sqlplus /nolog
SQL>connect sys /as sysdba

SQL> alter table ABC_OPEN add(FILE_NAME varchar2(30));
SQL> alter table ABC_COURSECODE add(FILE_NAME1 varchar2(30), FILE_NAME2 varchar2(30), FILE_NAME3 varchar2(30), FILE_NAME4 varchar2(30), FILE_NAME5 varchar2(30));
SQL> alter table ABC_COMPLETEUSER add(DIPLOMANUM NUMBER(7,0));

#>su - oracle

$>sqlplus /nolog

SQL>connect sys /as sysdba

SQL> alter table ABC_OPEN add(FILE_NAME varchar2(30));

SQL> alter table ABC_COURSECODE add(FILE_NAME1 varchar2(30), FILE_NAME2 varchar2(30), FILE_NAME3 varchar2(30), FILE_NAME4 varchar2(30), FILE_NAME5 varchar2(30));

SQL> alter table ABC_COMPLETEUSER add(DIPLOMANUM NUMBER(7,0));

테이블 변경

ALTER TABLE ABC_OPEN ADD( birth DATE) ;
ALTER TABLE ABC_OPEN MODIFY ename VARCHAR2(30) ;
ALTER TABLE ABC_OPEN DROP COLUMN ename ;
ALTER TABLE ABC_OPEN SET UNUSED (eno) ;
ALTER TABLE ABC_OPEN DROP UNUSED COLUMNS ;

ALTER TABLE ABC_OPEN ADD( birth DATE) ;

ALTER TABLE ABC_OPEN MODIFY ename VARCHAR2(30) ;

ALTER TABLE ABC_OPEN DROP COLUMN ename ;

ALTER TABLE ABC_OPEN SET UNUSED (eno) ;

ALTER TABLE ABC_OPEN DROP UNUSED COLUMNS ;

Mac 다양한 팁 SimpleCaptcha(캡차)의 Unix,Linux에서 sun.awt.X11GraphicsEnvironment 에러

Oracle DDL문 생성및관리

댓글 남기기 댓글 취소