How to insert multiple default values in a table

Question

Imagine you have a table which all of its columns were created with the DEFAULT clause included, for example

BOX
----------
height
width
depth

currently I'd make the following query to use default values:

INSERT INTO BOX VALUES(DEFAULT,DEFAULT,DEFAULT);

is there any other way to do this in Oracle? Preferably to indicate insert clause to use all default values but without specifying it for every column.

peterm · Accepted Answer · 2013-11-10 07:46:09Z

4

You can specify DEFAULT for one column and omit other columns.

INSERT INTO box (height) VALUES (DEFAULT);

As a result you'll get all columns with default values.

Here is SQLFiddle demo

answered Nov 10, 2013 at 7:46

peterm

93k16 gold badges157 silver badges162 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to insert multiple default values in a table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related