Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between sub query and nested query ?
- 19 Answers
- 68379 Views
- Keane India Ltd, TCS, I also Faced
- E-Mail Answers
Answer Posted / dinesh sahoo
The query inside a query is known as a subquery.
When we have another query again query inside subquery then
it is known as nested subquery, which resinde in the WHERE
clause.
| Is This Answer Correct ? | 12 Yes | 9 No |
Post New Answer View All Answers
How to pass a cursor variable to a procedure?
What is oracle update statement with inner join ?
Explain about achiever in sql?
What are the uses of a database trigger?
What is the difference between count (*), count (expression), count (distinct expression)?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What is PL/SQL ?
Explain rename?
What is tns service name?
Can you tell me how to add new column in existing views?how?How is possible?
How to export several tables together?
How to get a list of all background sessions in the database?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
Explain an extent?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
