Difference between sub query and nested query ?

Answer Posted / nirvaya

A subquery is a query within a query. In Oracle, you can
create subqueries within your SQL statements. These
subqueries can reside in the WHERE clause, the FROM clause,
or the SELECT clause. Most often, the subquery will be
found in the WHERE clause. These subqueries are also called
nested subqueries.

Is This Answer Correct ?    9 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

is there a tool to trace queries, like profiler for sql server?

840


How to establish administrator authentication to the server?

798


What are group functions in oracle?

789


How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1709


What is redo log?

817


Explain oracle instance.

922


What is open database communication (odbc) in oracle?

761


What is a trigger and what are its types?

824


What is logical backup in oracle?

798


What do you understand by a database object?

813


Explain the use of record length option in exp command.

828


Difference between cartesian join and cross join?

786


What is set operator oracle?

735


what is insert all statement in sql

5979


What is coalesce function?

793