Explain the different types of queries created in reports?
Answer Posted / Anju
"In Oracle D2K Reports, the following are the types of queries that can be created:
1. Simple Query: A query that retrieves data from a single table without any joins or conditions.
2. Complex Query: A query that retrieves data from multiple tables using joins and conditions.
3. Subquery: A query within another query, used to retrieve specific data.
4. View Query: A query that creates a virtual table, which can be used in other queries just like a regular table."n
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Were you involved in any data conversion, which one?
How many concurrent programs you have customized, can you name some of them?
Have you used lexical parameters in reports?
Any work done in oracle workflow builder. Did you customize or build a new workflow?
Are you familiar with user exits in reports?