Difference between sub query and nested query ?
Answer Posted / dinesh sahoo
The query inside a query is known as a subquery.
When we have another query again query inside subquery then
it is known as nested subquery, which resinde in the WHERE
clause.
| Is This Answer Correct ? | 12 Yes | 9 No |
Post New Answer View All Answers
What are the logical operations?
is there a tool to trace queries, like profiler for sql server?
How can you use check constraints for self referential integrity?
Explain about integrity constraint?
Can we store images in oracle database?
What is the difference between hot backup and cold backup in oracle?
What to do if dba lost the system password?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
what is meant by magic query
interview questions with answer for cts
How to create an oracle database?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
How to write text literals in oracle?
What is format trigger?
What do you mean by cdb and pdb in oracle 12c?