Override the defaults by specifying a value for the columns : Default Column Value « Table « Oracle PL/SQL Tutorial

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

SQL>
SQL> CREATE TABLE myTable (
  2    id INTEGER,
  3    status VARCHAR2(20) DEFAULT 'Order placed' NOT NULL,
  4    last_modified DATE DEFAULT SYSDATE
  5  );

Table created.

SQL>
SQL>
SQL>
SQL> INSERT INTO myTable (id, status, last_modified)
  2  VALUES (2, 'Order shipped', '10-JUN-2004');

1 row created.

SQL>
SQL> select * from myTable;

        ID STATUS               LAST_MODI
---------- -------------------- ---------
         2 Order shipped        10-JUN-04

SQL>
SQL> drop table myTable;

Table dropped.

SQL>
SQL>