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
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
How to add a new column to an existing table with a default value?
What are the types of partitions in oracle?
What is oracle server autotrace in oracle?
What is data block in Oracle?
what's query optimization and without use of IN AND Exist can we get another way data from query
Is there a function to split a string in plsql?
What privilege is needed for a user to create indexes in oracle?
Explain oracle 12c new features for developers?
Explain a segment?
Give the different types of rollback segments.
what is the difference between substr and instr function in oracle?
What is program global area (pga) in oracle?
What are the differences between char and varchar2 in oracle?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?