Create table called as newemp. Using single command create this table as well as get data into this table(use create table as);

Jitendrasoft09
Posted by Jitendrasoft09 under Oracle category on | Points: 40 | Views : 755
create table newemp as select * from emp;

SQL>Create table called as newemp. This table should contain only
empno,ename,dname.

Comments or Responses

Login to post response