Difference between sub query and nested query ?

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


Please Help Members By Posting Answers For Below Questions

How to delete a column in an existing table in oracle?

793


Is insert autocommit in oracle?

779


How to update a table row with a record?

767


What are the limitations oracle database 10g xe?

753


Explain about your project and its relation to the current job position you are applying to?

751


How to define an anonymous procedure with variables?

737


What is Data Dictionary Cache in Oracle?

888


How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

1799


How do I spool to a csv formatted file using sqlplus?

705


I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2074


What is data type in oracle?

755


What is sequence?

813


How to resolve the ORA-39133 error in Oracle?

786


What is a view and how is it different from a table?

718


What is the difference between "as" and "is" in an oracle stored procedure?

739