Oracle/SQL Fundamentals I

11일차 # 9-7: Default option

Bohemian life 2012. 4. 18. 15:46

        drop table t1 purge;

drop table t2 purge;


create table t1

 (no number,

  name varchar2(20),

  h_date date default sysdate);


desc t1;



        insert into t1 values (1000, 'James', to_date('02-01-11', 'MM-DD-YY'));

insert into t1 (no, name) values (2000, 'Clark');


select * from t1;