1.

Create view Dept20 with EmpName and the Sal of employees for dept 20.

Answer»

CREATE VIEW dept20 as SELECT empname, sal FROM emp WHERE deptno=20; 



Discussion

No Comment Found

Related InterviewSolutions