insert into a table with selected columns.

[Blessy]

how to insert a selected columns in a particular table.

supposing create table emp
(
eno number(3),
ename varchar2(20),
comapnay varchar2(30));

in this i have enter only employee number and employee name.

so how to insert only selected columns in a table.

could you pls help me at the earliest.

[debasisdas]

you need to specify the name of column you wan to insert value into.

This will insert null to other fields,provided that the other fields accepts NULL entry.

[CODE=oracle]insert into emp(eno,ename) values (eno1,'ename1') ;[/CODE]