Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
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 |