Difference between sub query and nested query ?
Answer Posted / mohammed al-fahed
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 ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is ceil and floor in oracle?
How would you change old and new values in an insert, delete and update triggers?
What is program global area (pga) in oracle?
What are privileges and grants?
How to store only time; not date and time?
what is difference between sql plus and sql*plus? (not sql and sql plus).
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
How to convert csv to table in oracle?
How does the on-delete-cascade statement work?
How to use existing values in update statements using oracle?
Explain cascading triggers.
Explain drop constraint oracle?
Can we save images in a database and if yes, how?
How to define an anonymous block?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??