Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Outer join and Full outer join?
- 5 Answers
- 40348 Views
- I also Faced
- E-Mail Answers
Answer Posted / sakshisree
Outer Join:
There are three types of outer joins namely:
Left Outer Join---For retreiving all the columns from the
first table irrespective of the column match.
Right Outer Join---For retreiving all the columns from the
second table irrespective of the column match
Full Outer Join---For retreiving all the columns from both
the tables irrespective of column match.
| Is This Answer Correct ? | 38 Yes | 12 No |
Post New Answer View All Answers
Explain the dml?
How to use "in out" parameter properly?
What is the data type of dual table?
What is an index associated with a constraint?
Can sub procedure/function be called recursively?
What do you understand by a database object?
defination of bitmap index
How do I manually uninstall oracle client?
What is the dynamic sql in oracle?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is a database schema in oracle?
What is ASM (Automatic Storage Management) in Oracle?
How to view the tablespaces in the current database?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Is there any function in oracle similar like group_concat of mysql?
