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
- 10092 Views
- Cognizant, IBM, I also Faced
- E-Mail Answers
Answer Posted / hadeera
A.X=B.X(+)
Is left outer join.
It gives all the values of column x table A.
And the values of column X TABLE B of those records which
match the records.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is a rollback possible to any savepoint?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
What is the scope of a local variable?
What are the restrictions on external table columns?
Explain an exception?
What are the oracle differences between nvl and coalesce
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
Is oracle the best database?
What is recovery manager in Oracle?
How to do paging with oracle?
Can we write dml statement in function in oracle?
how to do daily transactions with out sql* loader control file regesterd in apps?
What is a trigger and what are its types in oracle?
What happens if the update subquery returns multiple rows?
How to rename an existing table?
