VIEW: QPR.QPR_CUBES#

Source

View Text - Preformatted

select CUBE_ID CUBE_ID, CUBE_CODE CUBE_CODE, PRICE_PLAN_ID PRICE_PLAN_ID, CUBE_PPA_CODE CUBE_PPA_CODE, TEMPLATE_FLAG TEMPLATE_FLAG, SEEDED_FLAG SEEDED_FLAG, CUBE_SHORT_NAME CUBE_SHORT_NAME, CUBE_LONG_NAME CUBE_LONG_NAME, CUBE_PLURAL_NAME CUBE_PLURAL_NAME, CUBE_AUTO_SOLVE_FLAG CUBE_AUTO_SOLVE_FLAG, DEFAULT_DATA_TYPE DEFAULT_DATA_TYPE, PARTITION_HIER PARTITION_HIER, PARTITION_LEVEL PARTITION_LEVEL, SPARSE_TYPE_CODE SPARSE_TYPE_CODE, USE_GLOBAL_INDEX_FLAG USE_GLOBAL_INDEX_FLAG, AGGMAP_NAME AGGMAP_NAME, AGGMAP_CACHE_STORE AGGMAP_CACHE_STORE, AGGMAP_CACHE_NA AGGMAP_CACHE_NA, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, REQUEST_ID REQUEST_ID from "QPR"."QPR_CUBES"

View Text - HTML Formatted

SELECT CUBE_ID CUBE_ID
, CUBE_CODE CUBE_CODE
, PRICE_PLAN_ID PRICE_PLAN_ID
, CUBE_PPA_CODE CUBE_PPA_CODE
, TEMPLATE_FLAG TEMPLATE_FLAG
, SEEDED_FLAG SEEDED_FLAG
, CUBE_SHORT_NAME CUBE_SHORT_NAME
, CUBE_LONG_NAME CUBE_LONG_NAME
, CUBE_PLURAL_NAME CUBE_PLURAL_NAME
, CUBE_AUTO_SOLVE_FLAG CUBE_AUTO_SOLVE_FLAG
, DEFAULT_DATA_TYPE DEFAULT_DATA_TYPE
, PARTITION_HIER PARTITION_HIER
, PARTITION_LEVEL PARTITION_LEVEL
, SPARSE_TYPE_CODE SPARSE_TYPE_CODE
, USE_GLOBAL_INDEX_FLAG USE_GLOBAL_INDEX_FLAG
, AGGMAP_NAME AGGMAP_NAME
, AGGMAP_CACHE_STORE AGGMAP_CACHE_STORE
, AGGMAP_CACHE_NA AGGMAP_CACHE_NA
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, REQUEST_ID REQUEST_ID
FROM "QPR"."QPR_CUBES"