Skip navigation.

SQL and PL/SQL

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;