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

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.