Hi Friends, Query inside a query is called as Sub query. Sub query is

Difference between sub query and nested query ?

Question Posted / reddy

Answer Posted / reddy

Hi Friends,

Query inside a query is called as Sub query. Sub query is
also called as Nested Query.

Thanks
REDDY

Is This Answer Correct ?

22 Yes

41 No

Please Help Members By Posting Answers For Below Questions

What is a read write transaction in oracle?

1031

What is a dynamic performance view in oracle?

948

What is SQL access advisor in Oracle?

1136

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2292

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2072

How to use subqueries with the in operator using oracle?

1030

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2093

What are the uses of a database trigger?

926

Explain the use of parfile option in exp command.

988

How to define an explicit cursor in oracle?

985

Can you tell me how to add new column in existing views?how?How is possible?

1370

How to run create database statement?

975

How can windows applications connect to oracle servers?

983

What is catalog in Oracle?

1264

How to use "in" parameter properly?

1002