Reports in the GLOBAL Schema Folder: This screen capture of Analytic Workspace Manager shows the navigation tree on the left and the report on the right.
The tree shows the following:
Databases folder (expanded)
olap112 (global) - OLAP 11g folder (expanded)
Schemas folder (expanded)
GLOBAL schema folder (expanded)
Analytic Workspaces folder (collapsed)
My Tables folder (with the button icon, expanded)
Data Security Roles
My SQL Reports
The report shows the query, SELECT column_name, data_type FROM all_tab_columns WHERE. The remainder of the SELECT statement, which is owner = ? and table_name = ?, is not visible. The query results are:
COLUMN_NAME column: ACCOUNT_ID, FIRSTNAME, LASTNAME, ADDRESS, ADDRESS2, CITY, STATE_PROV, COUNTRY, ZIP_PC, PHONE, FAX, EMAIL.
DATA_TYPE column: VARCHAR2 for all rows.