Menu
I have an oracle table with a sequence and a trigger to autoincrement a column. Now I want to make an insert. Normally I should write:
INSERT INTO table (column1, column2,...) VALUES (value1, value2)
but I just want to insert a record with no default values. How to do this in Oracle?
`Mysql`: INSERT INTO table () VALUES ()
`Mssql`: INSERT INTO table default VALUES
`Oracle:` INSERT INTO table (column1, column2,...) VALUES (default, default,...)
Is this the only way? I have to list all columns?
264
There are two ways of using INSERT INTO statement for inserting rows: Only values: First method is to specify only the value of data to be inserted without the column names. INSERT INTO table_name VALUES (value1, value2, value3,…); table_name: name of the table.
INSERT statements can also be executed without the specification of column names. To execute an INSERT statement without typing the column names, specify the values in the same order that the columns appear in the table. Look at Example-F, which inserts an additional record into the Toys table.
As long as you have the right number of columns in your INSERT statement, and as long as all the values except KEYBOARD are some numeric data type, and as long as you have suitable permissions, this should work. INSERT INTO INVOICE VALUES( 1,1,'KEYBOARD',1,15,5,75);
INSERT INTO table (column1) VALUES (default);
The rest will be defaulted!
107
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
