Collections:
Other Resources:
Specify Default Values in INSERT Statements in Oracle
How To Specify Default Values in INSERT Statement in Oracle?
✍: FYIcenter.com
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
2016-10-16, 315👍, 0💬
Popular Posts:
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
How To Create a View on an Existing Table in SQL Server? If you want to a view on an existing table,...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...