What is the definition of derived table ?
Answers were Sorted based on User's Feedback
Answer / subramanyam
Derived table is nothing but logical table like view.it
doesn't carry out any data in the database.It is the
function in the designer. You can use the view as the table
in the universe design and you can create the class objects
and conditions based on that derived table.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / kumarreddy
A derived table is one that is created on-the-fly using the
SELECT statement, and referenced just like a regular table
or view. Derived tables exist in memory and can only be
referenced by the outer SELECT in which they are created.
| Is This Answer Correct ? | 4 Yes | 0 No |
How to create Index to the table in the universe designer and how it improves the Query performence
what is variable ?
how to create reports on screech?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
What is the differrence between prompt & @prompt? What is the differrence between Xcelsius & Web-I Report?
What is the user Object ? What is the need of it?
How do you restrict access to rows of a database?
WHAT ARE TEMPLATES? EXPLAIN WHAT YOU HAVE CREATED?
What is a category?
how we send repotrts/documents to end user
I HAVE MONTHS AS DEC,JEN,MAY,APRIL... WHICH PROMPT IS USED TO GET REPORT IN SEQUENCE?
hi my question is in a report table how can we write table header without using of individual cell.can we merge column cells togrther??