column with default as sysdate : Column Default Value « Table « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Table
  3. Column Default Value

column with default as sysdate

    
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>








Related examples in the same category

1.Override the defaults by specifying a value for the columns
2.Create table with column having the default value
3.Use rpad to fill default value to a column
4.null with default value column
5.Default char value
6.Default varchar value
7.Use char function to build default column value