Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Table

 

Date type column with current date as the default value

SQL> SQL> create table WORK_T (   2  id                             number,   3  code                           varchar2(30),   4  name                           varchar2(80),   5  active_date                    date          default SYSDATE  not null,   6  inactive_date                  date ); Table created. SQL> SQL> drop   table WORK_T; Table dropped. SQL>