Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between sub query and nested query ?
- 19 Answers
- 67609 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
How to use "in out" parameter properly?
List the parts of a database trigger.
How to create a stored function in oracle?
What is instant client oracle?
What are temporal data types in oracle?
Respected sir, Please send me technical questions related to oracle apps..
Where do we use decode and case statements?
What is the disadvantage of User defind function?
What is a package in oracle?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
Differentiate between post-database commit and post-form commit?
Difference between hot backup vs. Cold backup?
How to start your 10g xe server from command line?
What is a cognitive schema?
When do I need to use a semicolon vs a slash in oracle sql?
