Difference between sub query and nested query ?
- 19 Answers
- 64855 Views
- Keane India Ltd, TCS, I also Faced
- E-Mail Answers
Answer Posted / vrushali
Co-related sub query is one in which inner query is
evaluated only once and from that result outer query is
evaluated.
Nested query is one in which Inner query is evaluated for
multiple times for gatting one row of that outer query.
ex. Query used with IN() clause is Co-related query.
Query used with = operator is Nested query
| Is This Answer Correct ? | 8 Yes | 68 No |
Post New Answer View All Answers
What is object data modeling?
What is a synonym? What are its various types?
What is columnar storage what is the advantage?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
Explain what are the type of synonyms?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
Explain what are the characteristics of data files?
What is the purpose of save points in oracle database?
How to create a temporary table in oracle?
Explain the difference between a procedure and a function?
Explain the different normalization forms?
How to manage transaction isolation level?
What is meant by joins?
What is clustered table in Oracle?
How to create an oracle database?
