A and B are tables. x is a column. Then What is difference
between A.x = B.x(+) and A.x = B.x ?
Answer Posted / guest
the difference between A.x=B.x(+) is a outer join and
A.x=B.x is a inner join.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are set operators?
Explain enable novalidate constraint.
Explain integrity constraints?
How to store pictures on to the database?
How to resolve the ORA-39133 error in Oracle?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
What is meant by a deadlock situation?
Why do you create or replace procedures rather that drop and recreate.
Explain the use of rows option in exp command.
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What is a nvl function? How can it be used?
What is the string concatenation operator in oracle?
How to pass a parameter to a cursor in oracle?
What are the ways tablespaces can be managed and how do they differ?