Mega Code Archive
Column with default as sysdate
<![CDATA[
SQL>
SQL> create table employee_history
2 ( employee_id number(6) not null,
3 salary number(8,2),
4 hire_date date default sysdate,
5 termination_date date,
6 termination_desc varchar2(4000),
7 constraint emphistory_pk
8 primary key (employee_id, hire_date)
9 )
10 /
Table created.
SQL> describe employee_history
Name Null? Type
----------------------------------------------------------------------------------------------------------------- -------- ----------------------------------------------------------------------------
EMPLOYEE_ID NOT NULL NUMBER(6)
SALARY NUMBER(8,2)
HIRE_DATE NOT NULL DATE
TERMINATION_DATE DATE
TERMINATION_DESC VARCHAR2(4000)
SQL>
SQL>
SQL> drop table employee_history;
Table dropped.
SQL>
]]>