what is correlated subquery

Answers were Sorted based on User's Feedback



what is correlated subquery ..

Answer / g.v.prasad

It is Another Way of Performing queries upon the data with a
simulation of joins

in this the information from the OUTER SELECT statement
participates as a condition in the INNER SELECT statement

Is This Answer Correct ?    1 Yes 0 No

what is correlated subquery ..

Answer / ruba

outer query is first executed and then outerquery was used
by the inner query

Is This Answer Correct ?    0 Yes 0 No

what is correlated subquery ..

Answer / naveen

Inner Query refers outer query refers inner Query

we can take an example of Inline View

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Oracle AllOther Interview Questions

A Table has 10,000 records,How can i get latest 10 dates from the table.so that i can only store those 10 records in to my Resultset Object,to reduce load on my app?

7 Answers   TCS,


What do you mean by hz_ in customer tables? : oracle accounts receivable

0 Answers  


Explain an ORA-01555

2 Answers  


Name two files used for network connection to a database.

1 Answers  


What is the sql query to find the employee who has Nth maximum salary?

2 Answers  






why r u using etl tool.

2 Answers  


which gives Oracle R12 Financial training in delhi please give me answer its urgent?

0 Answers  


Where would you look for errors from the database engine?

2 Answers   Fintellix,


key flexfield structure

0 Answers   Infosys,


Whats the purpose of using Nextval while creating the sequence.

2 Answers   HCL,


what is sql*loader parameters and where we will use it.

1 Answers   Accenture,


I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)