Difference between sub query and nested query ?
Answer Posted / roopesh kumar
Main Diff. b/w Subquery & Nested Subquery:
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.
| Is This Answer Correct ? | 25 Yes | 36 No |
Post New Answer View All Answers
How many types of synonyms in Oracle?
How many file formats are supported to export data?
State any two functions of oracle?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
How do I learn what codesets are available in oracle?
How to define an oracle sub procedure?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
Will you be able to store pictures in the database?
What is the implicit cursor in oracle?
What is parameterized cursor in oracle?
How translate command is different from replace?
How can I combine multiple rows into a comma-delimited list in oracle?
How to execute a stored procedure in oracle?
Is insert autocommit in oracle?
How to delete a column in an existing table in oracle?