Interested to Buy Any Domain ? << Click Here >> for more details...
A and B are tables. x is a column. Then What is difference
between A.x = B.x(+) and A.x = B.x ?
- 7 Answers
- 10090 Views
- Cognizant, IBM, I also Faced
- E-Mail Answers
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
Is insert autocommit in oracle?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
How to build data dictionary view an new database?
How to use subqueries with the in operator using oracle?
What are the oracle built-in data types?
What is Java Pool in Oracle?
How do I limit the number of rows returned by an oracle query after ordering?
What is a subquery?
Is java required for oracle client?
What is oracle host variable?
How to use "while" statements in oracle?
How to manage transaction isolation level?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
Is primary key indexed by default in oracle?
What is program global area (pga) in oracle?
