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

Jitendrasoft09
Posted by Jitendrasoft09 under Oracle category on | Points: 40 | Views : 651
create table newemp as select empno,ename,dname from emp,dept where
1=2;

Comments or Responses

Login to post response