Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between sub query and nested query ?
- 19 Answers
- 68540 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 a oracle database?
How to connect the oracle server as sysdba?
How do I uninstall oracle client from windows?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
Why do we need oracle client?
What is background process in Oracle?
Explain the use of inctype option in exp command.
How remove data files before opening a database?
What is rowid and rownum in oracle?
What is an oracle?
Is oracle an open source?
How to assign query results to variables?
What is meant by an index?
How to define a procedure inside another procedure?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
