Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between sub query and nested query ?
- 19 Answers
- 68482 Views
- Keane India Ltd, TCS, I also Faced
- E-Mail Answers
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
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
how to join query for one source type is oracle another source type is sql server ?
What is the disadvantage of User defind function?
How to use "in" parameter properly?
What is the difference between alert log file and tarce file ?
How to run create database statement?
Why is oracle database so popular?
How to define a specific record type?
What is materialized view in Oracle?
How to export your own schema?
What do database buffers contain?
How to assign values to data fields in record variables?
What are the parameters that we can pass through a stored procedure?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
Difference between pre-select and pre-query
