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 / pradeep
A.x = B.x(+) is a left outer join and it will return
all the values of x from A table.
A.x = B.x is a inner join.
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What is the usage of save points in oracle database?
Explain what does a control file contain?
what are archived logs?
Explain about achiever in sql?
How to initialize variables with default values?
How to connect the oracle server as sysdba?
Who developed oracle & when?
How to manage transaction isolation level?
What is coalesce function?
what is the difference between data migration and production migration.
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
How to convert characters to numbers in oracle?
What is an oracle database?
What happens if you use a wrong connect identifier?