The join defined by the default data link is an outer join
yes or no ?
Answer / meenakshi
No its not outer join
but it is an equi/natural join
Is This Answer Correct ? | 6 Yes | 0 No |
Do you know about aggregate functions? What is row num function? Can it be used all databases?
1 Answers Bravura Solutions, Cap Gemini,
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
How to rename an index in oracle?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What are the components of Logical database structure of ORACLE database?
Explain about achiever in sql?
is there a tool to trace queries, like profiler for sql server?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
How to delete a column in an existing table?
Explain the use of ignore option in imp command.
How to convert characters to times in oracle?
How to use "in out" parameter properly?