Whatz the main diff between Subquery and a Join
Answer Posted / suramya biswas
Sub Query can be used for UPDATE,DELETE statements where as
Join Query is only used in SELECT statement
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is null value in oracle?
Explain the use of record option in exp command.
What is the difference between sharding and partitioning?
What is an oracle function?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
What is an oracle tablespace?
What are the set operators union, union all, minus & intersect meant to do?
How to load excel data sheet to oracle database
Who developed oracle & when?
How would you go about verifying the network name that the local_listener is currently using?
What are the uses of synonyms?
In what script is snap$ created? In what script is the scott/tiger schema created?
What are the database administrators utilities available?
How can I get column names from a table in oracle?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?