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
How do we display rows from the table without duplicates?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
How to pass parameters to procedures?
How can I create database in oracle?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
How to find out what oracle odbc drivers are installed?
How to define a specific record type?
how to handle exceptions in post production
How to create a stored program unit?
How to save query output to a local file?
Is insert autocommit in oracle?
How to add a new column to an existing table with a default value?
How to call a sub procedure?
Explain the use of Merge statement in oracle 11g
How would you go about verifying the network name that the local_listener is currently using?