Collections:
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
⇒ Omit Columns in INSERT Statements in Oracle
⇐ Insert a New Row into a Table in Oracle
2020-01-29, 1157👍, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How To Create a Simple Stored Procedure in SQL Server Transact-SQL? If you want to create a simple s...
Where to find answers to frequently asked questions on SQL Transaction Management in Oracle? Here is...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...