How To Specify Default Values in INSERT Statement

Q

How To Specify Default Values in INSERT Statement? - Oracle DBA FAQ - Understanding SQL DML Statements

✍: 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

2007-04-21, 4717👍, 0💬