Outer Join, Inner Join and self join

various types of joins

Question Posted / raj

Answer Posted / raj

Is This Answer Correct ?

8 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain the use of file option in exp command.

1116

What types of joins are used in writing subqueries?

966

How would you begin to troubleshoot an ORA-3113 error?

2067

What is Undo Management Advisor in Oracle?

1080

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1918

What is a user role in oracle?

1102

How to lock and unlock a user account in oracle?

1082

What is oracle thin client?

1009

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2030

Difference between open_form and call_form in oracle.

1135

What is oracle data type?

942

In oracle there is column command, how will you explain that?

1021

How do we get field details of a table?

970

How remove data files before opening a database?

1049

How to use "in out" parameter properly?

1033