Oracle - Default Column Value

This article describes the column default values in Oracle.

Overview

Default
Syntax	DEFAULT expression
Description	The DEFAULT clause specifies a value to be assigned to the column if an INSERT statement omits a value for the column
Acceptable Expressions	1. Constants and string literals 2. SQL functions
Not Valid Expressions	1. References to PL/SQL functions 2. References to other columns 3. The CURRVAL, NEXTVAL, LEVEL, PRIOR, and ROWNUM pseudocolumns