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
is there a tool to trace queries, like profiler for sql server?
How to establish administrator authentication to the server?
What are group functions in oracle?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What is redo log?
Explain oracle instance.
What is open database communication (odbc) in oracle?
What is a trigger and what are its types?
What is logical backup in oracle?
What do you understand by a database object?
Explain the use of record length option in exp command.
Difference between cartesian join and cross join?
What is set operator oracle?
what is insert all statement in sql
What is coalesce function?