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
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
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.
What is the difference between substr and instr?
How to do paging with oracle?
Name the various constraints used in oracle?
State the difference between a primary key and foreign key?
How to rebuild an index in oracle?
How to store only time; not date and time?
Explain what are the type of synonyms?
What is an oracle wallet?
How to execute the package in oracle?
How to display row numbers with the records?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
How would you best determine why your MVIEW couldnt FAST REFRESH?