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

 

Understanding SQL DML Statements for Oracle

⇒⇒Oracle Database Tutorials

2016-10-16, 141👍, 0💬