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 is a schema in oracle?
How to omit columns with default values in insert statement in oracle?
Why is oracle database so popular?
Explain integrity constraint?
Explain the use of tables option in exp command.
Explain what are the uses of rollback segment?
Explain an exception and its types?
What is oracle update statement with inner join ?
What is the usage of analyze command in oracle?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
How to get execution statistics reports on query statements?
Difference between pre-select and pre-query
What is the relationship among database, tablespace and data file?
How to create a new user account in oracle?
How to drop an existing table in oracle?