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 |
What is ment by For each For all function. In which case we use the option in BO?
what is diff between Decode and case ? Give some Example?
2.What is loop? How resolve the loop?explain it?
11 Answers TCS, UHG,
What is difference between webi and infoview?
what is local filter
what is the difference btween olap and oltp?
What is the user Object ? What is the need of it?
my info view somehow stop working and when i try to open my info view or CMC both keep buffering in Internet explorer but unable to open please see if any one can help on it
what is the diff between etl tool and olap tool
How to display the top 5 records along with the additional records,plus their sub and grand totals to be display in the same block.
Explain how to execute the plsql procedure from the report by clicking with mouse?
How to get red line in the graph at some point (value)? Example : In graph at 200000 value