Insert record into a table with default value : Default Column Value « Table « Oracle PL/SQL Tutorial

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> INSERT INTO myTable (id)
  2  VALUES (1);

1 row created.

SQL>
SQL> select * from myTable;

        ID STATUS               LAST_MODI
---------- -------------------- ---------
         1 Order placed         02-JUN-07

SQL>
SQL> drop table myTable;

Table dropped.

SQL>

6.14.Default Column Value
	6.14.1.	Using Default Values
	6.14.2.	Insert record into a table with default value
	6.14.3.	Override the defaults by specifying a value for the columns
	6.14.4.	Update a column and set it back to the default using the DEFAULT keyword in an UPDATE statement
	6.14.5.	Update statement with default
	6.14.6.	Add a column with default value
	6.14.7.	Date type column with current date as the default value
	6.14.8.	null with default value column