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 / 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
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
Why do we need oracle client?
Name the various constraints used in oracle?
How to write a query with a right outer join in oracle?
Explain what does a control file contain?
How to list all tables in your schema?
What is meant by recursive hints in oracle?
What is dual table oracle?
Explain oracle insert into command?
How to run the anonymous block again?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Is oracle an open source?
Differentiate between post-database commit and post-form commit?
How to retrieve data from an cursor to a record?