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 categories of data types?
Explain overloading. Can functions be overloaded?
What is SQL Tuning Advisor in Oracle?
How can we find out the current date and time in oracle?
How to start instance with a minimal initialization parameter file?
What are the attributes that are found in a cursor?
How to define a variable of a specific record type?
How to connect the oracle server as sysdba?
What is archive log in Oracle?
How to assign a tablespace to a users in oracle?
How to recover a dropped table in oracle?
what is normalisation?what are its uses?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
types of indexes and the rationale behind choosing a particular index for a situation.
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??