Interested to Buy Any Domain ? << Click Here >> for more details...
How do you get all records from 2 tables. Which join do you use?
- 8 Answers
- 18971 Views
- Microsoft, I also Faced
- E-Mail Answers
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
Is crud a cuss word?
Is pl sql still used?
Why do we need cursors in pl sql?
Explain the difference in execution of triggers and stored procedures?
What is t sql used for?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
Explain mutating table error.
What do you mean by dbms? What are its different types?
Explain how can you save or place your msg in a table?
what is log shipping? : Sql dba
What is sql engine in oracle?
what is transaction? : Sql dba
Is not null in sql?
Is left join and outer join same?
What is cursor status?
