Specify Default Values in INSERT Statements in Oracle

Q

How To Specify Default Values in INSERT Statement in Oracle?

✍: FYIcenter.com

A

If a column is defined with a default value in a table, you can use the key word DEFAULT in the INSERT statement to take the default value for that column. The following tutorial exercise gives a good example:

INSERT INTO fyi_links VALUES (102, 
  'http://dba.fyicenter.com', 
  NULL,
  0,
  DEFAULT);
1 row created.

SELECT * FROM fyi_links;
   ID URL                      NOTES     COUNTS CREATED
----- ------------------------ -------- ------- ---------
  101 http://dev.fyicenter.com NULL           0 30-Apr-06
  102 http://dba.fyicenter.com NULL           0 07-MAY-06

 

Omit Columns in INSERT Statements in Oracle

Insert a New Row into a Table in Oracle

Understanding SQL DML Statements for Oracle

⇑⇑ Oracle Database Tutorials

2020-01-29, 1157👍, 0💬