Using Default Values : Default Column Value « Table « Oracle PL/SQL Tutorial






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

Define a default value for a column.

last_modified column is defaulted to the value returned by the SYSDATE function.

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> drop table myTable;

Table dropped.








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