ORACLE TABLE

CREATE TABLE

테이블 생성 예제

CREATE TABLE tb_admin (
  admin_no       NUMBER(10)
 ,admin_id       varchar2(20)
 ,last_update_dt DATE DEFAULT sysdate
);

컬럼추가	ALTER TABLE tb_admin ADD (admin_passwd varchar2(20) );
컬럼명변경	ALTER TABLE tb_admin RENAME COLUMN admin_id TO user_id;
컬럼속성변경	ALTER TABLE tb_admin MODIFY ( admin_no varchar2(20) );
컬럼삭제	ALTER TABLE tb_admin DROP (last_update_dt);