insert syntax
This is valid
INSERT INTO table () VALUES ()
But, is this valid?
INSERT INTO table VALUES ()
Extract from the manual:
If you do not specify a list of column names for INSERT ... VALUES or INSERT ... SELECT, values for every column in the table must be provided by the VALUES list or the SELECT statement.
Subject
Views
Written By
Posted
insert syntax
8972
March 12, 2006 08:01PM
3079
March 13, 2006 01:31AM
2900
March 13, 2006 01:33AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.