Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between sub query and nested query ?
- 19 Answers
- 68412 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 program global area (pga) in oracle?
How to use an explicit cursor without open statements?
How to initialize variables with default values?
what is the dual table in oracle?
Why should I use oracle database?
What do you know about normalization? Explain in detail?
What is blob datatype?
How to create an initialization parameter file?
Can a parameter be passed to a cursor?
What is a procedure in oracle?
How to loop through data rows in the implicit cursor?
What is the usage of save points in oracle database?
What suggestions do you have to reduce the network traffic?
How to define a variable to match a table column data type?
How to Truncate Table in Oracle
