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;