SQL and PL/SQL

Oracle SQL and PL/SQL FAQ's

about oracle

is it possible to insert one table column values into another table , if possible please help me with query

insert one table column values into another table


*insert into employee table empno column values into new_emp table eno column

insert into new_emp(eno) select empno from emp;