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
How to delete a column in an existing table in oracle?
Is insert autocommit in oracle?
How to update a table row with a record?
What are the limitations oracle database 10g xe?
Explain about your project and its relation to the current job position you are applying to?
How to define an anonymous procedure with variables?
What is Data Dictionary Cache in Oracle?
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.
How do I spool to a csv formatted file using sqlplus?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
What is data type in oracle?
What is sequence?
How to resolve the ORA-39133 error in Oracle?
What is a view and how is it different from a table?
What is the difference between "as" and "is" in an oracle stored procedure?