Write Insert into statement but omit two columns

Table A has 8 columns but I want to only insert data into 5 columns.

so specify the columns there...

Insert into A ( fname, lname, address, city, zip, ssn, gender, race )

for example:

Insert into A ( fname, lname, address, city, zip )
Values('Jo', 'Shine','44 darkness street', 'NY', 10047); 

Select allOpen in new window

providing other fields accepting null values.

Yes the syntax you posted is legal in Oracle.  That assumes the other three columns do not have NOT NULL constraints.

Have you tried this insert command?  Does it succeed or give you an Oracle error?  If it fails, which Oracle error does it return?

Can you skip columns not in order in a insert? Can you provide an example?

As long as you specify the column list on the insert side, the columns can be in whatever order you want.  Just adjust the values as well.

This works just fine:
 Insert into A (  city, zip, ssn, gender, race, fname, lname, address )
 Values('NY', 10047,'Jo', 'Shine','44 darkness street');

Should add:  The column order only matters when you do not provide the actual column names.

This may run but will put data into the wrong columns:
Insert into A
 Values('NY', 10047,'Jo', 'Shine','44 darkness street');

I do not want to insert data in all the colums, and  the data is coming from another procedure. The columns are not in order that i want to insert data into. It's a i
Insert into ( .)
Values(...)

>>I do not want to insert data in all the colums

We understand that and others have shown that as long as you specify the specific columns, it works.  You then asked about column order and as long as you specify the column names, order doesn't matter.

As long as the values provided matches up with the order of the column names, it works.

These work and are the same:
 Insert into A (  city, zip) Values('NY', 10047);
 Insert into A (  zip,city) Values(10047,'NY');

You only get into problems when the columns and values don't match.  This might run or it might generate an error.  If it runs, you end up with wrong data in wrong columns:
 Insert into A (  zip,city) Values('NY',10047);

So, i don't include the colums don't worry but if i do include them it has to match tge order.
Insert into( a, b, c , d,,g, j)
Values(Apple, bear, cat, dog, goat)

The other columns that have letters for animals in order don't worry about them, right

Correct, you do not need to include all column names when you do an insert.  But, then you must list the column names (in any order) that want to insert values into, and you must provide the values for those columns *IN THE SAME ORDER* that you list the column names in.

Yes, you don't include the column names but you don't skip over them.

Look at the syntax I've been posting.  I don't have two commas side by side (,,).

It should be:
Insert into( a, b, c , d, g, j)

>>Values(Apple, bear, cat, dog, goat)

For strings, you need to wrap them in single quotes:
Values('Apple', 'bear', 'cat', 'dog', 'goat')

Now the insert you last posted has 6 columns but your values clause has 5 entries.  They need to match.

>>The other columns that have letters for animals in order don't worry about them, right

I don't know what you mean by this.

The best. Thanks