Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Omit Columns with Default Values in INSERT Statement
How To Omit Columns with Default Values in INSERT Statement? - Oracle DBA FAQ - Understanding SQL DML Statements
✍: FYIcenter.com
If you don't want to specify values for columns that have default values, or you want to specify values to columns in an order different than how they are defined, you can provide a column list in the INSERT statement. If a column is omitted in the column, Oracle applies 3 rules:
The following tutorial exercise gives a good example:
INSERT INTO fyi_links (url, id) VALUES ('http://sqa.fyicenter.com', 103); 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 103 http://sqa.fyicenter.com NULL NULL 07-MAY-06
2007-04-21, 4616👍, 0💬
Popular Posts:
How can a servlet refresh automatically if some new data has entered the database? You can use a cli...
Which one of the following statements is TRUE in regard to overloading the ++ operator? 1 You cannot...
How To Decrement Dates by 1? - MySQL FAQs - Introduction to SQL Date and Time Handling If you have a...
How To Use "IN OUT" Parameter Properly? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and F...
.NET INTERVIEW QUESTIONS - Is versioning applicable to private assemblies? Versioning concept is onl...