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
2020-01-29, 718👍, 0💬
Popular Posts:
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
How To Create a Stored Function in Oracle? A stored function is a function with a specified name and...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
What Is Open Database Communication (ODBC) in Oracle? ODBC, Open Database Communication, a standard ...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...