1. Use subquery In the create table statement
By using subqueries In the create table statement, you can insert data in the table while creating a new table. SQL> Create Table dept1 (deptno, dname, Loc) as select deptno, dname, LOC from Dept; if it is to create all columns, you can use * to simplify the statement. SQL> Create Table emp1 as select * from EMP; 2. Use the subquery SQL in the update Statement> Update emp1 set (SAL, comm) = (select Sal, comm from emp1 where enmae = 'ward ') where job = (select job from emp1 where enmae = 'ward '); 3. Use the subquery SQL> Delete emp1 where deptno = (select deptno from dept1 where dname = 'accounting') in the delete statement '); 4. Using subqueries in an insert statement by using subqueries in an insert statement, you can insert datasets in one table into another table. SQL> insert into emp1 select * from EMP where deptno = (select deptno from Dept where dname = 'accounting ');
