InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Are The Utilities Of Derived Tables? |
|
Answer» Using SQL queries from the database level, Derived tables are created in the universe. The columns of the derived table will be the columns selected in the query. Derived table can be used in the complex calculations which are DIFFICULT to be achieved in the report levels. Using a dblink, tables can be ACCESSED from a different schema, is ANOTHER USE of derived tables. Using SQL queries from the database level, Derived tables are created in the universe. The columns of the derived table will be the columns selected in the query. Derived table can be used in the complex calculations which are difficult to be achieved in the report levels. Using a dblink, tables can be accessed from a different schema, is another use of derived tables. |
|