what is different between inline query,subquery& corelated
query?
Answer Posted / dhana
An inline view is a SELECT statement in the FROM-clause of
another SELECT statement. In-line views are commonly used
simplify complex queries by removing join operations and
condensing several separate queries into a single query.
This feature was introduced in Oracle 7.
| Is This Answer Correct ? | 79 Yes | 13 No |
Post New Answer View All Answers
default triggers available for reports
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
What is the difference between oracle media recovery and crash recovery?
1. What is PO rate variance gain and loss?
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
3. Steps in UAT?
i want to know about the javaBean.what is its purpose and how it can use in Forms.
what are basic modules required to implement oracle application in any oraganisation?
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
What is the sql query to find the employee who has Nth maximum salary?
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks