Answer Posted / madhav
Full outer join
select e.empno,e.ename,e.deptno,e.sal,d.deptno,d.dname from
emp e full outer join dept d
on e.deptno=d.deptno;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Advantages and disadvantages of stored procedure?
What is sap sql?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
How do you delete a table?
Explain two easy sql optimizations.
Can sql function call stored procedure?
When you have to use a default "rollback to" savepoint of plvlog?
Explain the order of sql statement execution?
What is the difference between truncate and drop statements?
what is the bond code in materialized view?
What are joins in sql?
What is mutating sql table?
Can we insert data into view?
How do you use a while loop in pl sql?
Why is nosql good?