Im trying to create a pivot table in Excel using the following data The end result Im trying to come up with using the pivot is a summary like this However I. SELECTPurpose. Use a SELECT statement or subquery to retrieve data from one or more tables, object tables, views, object views, or materialized views. If part or all of the result of a SELECT statement is equivalent to an existing materialized view, then Oracle Database may use the materialized view in place of one or more tables specified in the SELECT statement. This substitution is called query rewrite. It takes place only if cost optimization is enabled and the QUERYREWRITEENABLED parameter is set to TRUE. To determine whether query write has occurred, use the EXPLAINPLAN statement. Prerequisites. For you to select data from a table or materialized view, the table or materialized view must be in your own schema or you must have the SELECT privilege on the table or materialized view. For you to select rows from the base tables of a view You must have the SELECT privilege on the view, and.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2017
Categories |