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 out parameter used for eventhough return statement can also be used in pl/sql?
What are the different tcl commands in sql?
What is cte?
How do you modify a table in sql?
What is pl sql in oracle?
Determine if oracle date is on a weekend?
What is the least restrictive isolation level? : Transact sql
what are myisam tables? : Sql dba
what is 'mysqlcheck'? : Sql dba
Why plvtab is considered as the easiest way to access the pl/sql table?
What are the parts of a basic sql query?
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
What is the difference between having and a where in sql?
how to convert dates to character strings? : Sql dba
How do I quit sql?