create table t1
(
id$ integer not null,
charcol char default 'Y',
datecol date default sysdate,
strcol varchar2(30) default user,
intcol integer default 12
);
insert into t1 (id$) values (1);
select * from t1; ID$ C DATECOL STRCOL INTCOL
---------- - --------- ------------------------------ ----------
1 Y 28-MAY-04 SCOTT 12
(
id$ integer not null,
charcol char default 'Y',
datecol date default sysdate,
strcol varchar2(30) default user,
intcol integer default 12
);
insert into t1 (id$) values (1);
select * from t1; ID$ C DATECOL STRCOL INTCOL
---------- - --------- ------------------------------ ----------
1 Y 28-MAY-04 SCOTT 12
2 (
3 AA DATE default sysdate,
4 BB VARCHAR2(10)
5 )
6 /Table createdSQL> insert into aa(bb) values('bb');1 row insertedSQL> commit;Commit completeSQL> select * from aa;AA BB
----------- ----------
2005-12-21 bb