Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between sub query and nested query ?
- 19 Answers
- 68999 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
why dont we assign not null constraint as table level constraint.
how to make an oracle object
What are privileges and grants?
Explain oracle left join with an example?
What is the maximum number of triggers that can be applied to a single table?
What is a initialization parameter file in oracle?
What is a cursor in oracle?
How can I create database in oracle?
What is oracle server autotrace in oracle?
What is snapshot is too old? Give and example for better understand.
How do I limit the number of rows returned by an oracle query after ordering?
What do you mean by merge in oracle and how can we merge two tables?
What is an Oracle Instance?
How can you use check constraints for self referential integrity?
How to use windows user to connect to the server?
