How do you get all records from 2 tables. Which join do you use?
Answer Posted / kavithanedigunta
full outer join in 10 g
select a.*,d.dname
from emp a
full outer join
dept d on
a.DEPTNO = d.DEPTNO
full outer join in 9i
select a.* ,d.DNAME
from emp a, dept d
where a.DEPTNO = d.DEPTNO
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is recursive stored procedure?
What is difference between sql function and stored procedure?
Explain table and field in sql?
How to find 3rd highest salary of an employee from the employee table in sql?
what is sql in mysql? : Sql dba
what are the difference between clustered and a non-clustered index? : Sql dba
what are the disadvantages of mysql? : Sql dba
Is it possible to include an insert statement on the same table to which the trigger is assigned?
Mention what are the benefits of pl/sql packages?
how many ways to get the current time? : Sql dba
what are the features and advantages of object-oriented programming? : Sql dba
What is data profiling in sql?
What is varchar sql?
How do you bind variables in pl sql?
Is big data nosql?