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 / surya
A.x = B.x(+) is outer join.
A.x = B.x is inner join of two tables
Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
What is a package ? What are the advantages of package ?
How to delete an existing row from a table in oracle?
Is there a combination of "like" and "in" in sql?
Give the advantages and disadvantages of clusters.
How to create a new table by selecting rows from another table?
What happens if the update subquery returns multiple rows?
What is the scope of a local variable?
Can group functions be used in the order by clause in oracle?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
What is the minimum client footprint required to connect c# to an oracle database?
How a database is related to tablespaces?
Explain the function of optimizer in oracle?
How to create a new table in your schema?