Whatz the main diff between Subquery and a Join
Answer Posted / anbu
their should be a relationship between the tables then only
we can use join conditions....
But the subquery can be used to retrive data from one or
more table if their is no relation between the tables....
Is This Answer Correct ? | 17 Yes | 4 No |
Post New Answer View All Answers
Can you assign multiple query result rows to a variable?
How can we create the complete backup of data in the oracle.
How to bring a tablespace online?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
What are the roles of dba?
What is oracle host variable?
what is the dual table in oracle?
Difference between varchar and varchar2 data types?
What is bulk load in oracle?
How to convert raw data type into text in oracle? Explain
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
Can objects of the same schema reside in different tablespace?
What is the difference between a hot backup and a cold backup in oracle?
What is program global area (pga) in oracle?