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 / subha
A.x=B.x(+) will display all the vlaues of X from B table
and Deficient information of A table.
IT is right outer join concept.
where as
A.x=B.x will display records that are matching from both
the tables.
Is This Answer Correct ? | 11 Yes | 5 No |
Post New Answer View All Answers
Use of an integrity constraint is better to validate data. Explain
What is the difference between view and materialized view in Oracle?
What is the quickest way to fetch the data from a table?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
How to create a new view in oracle?
How to create a table in a specific tablespace?
How to delete a column in an existing table?
Explain coalesce function?
What happens to the current transaction if the session is ended?
What are the tools for Oracle ?
What privilege is needed for a user to insert rows to tables in another schema?
Can we write dml statement in function in oracle?
How many types of table in Oracle?
How to delete multiple rows from a table in oracle?
What is the difference between "as" and "is" in an oracle stored procedure?