VIEW: CZ.CZ_EXPRESSION_NODES#

Source

View Text - Preformatted

select LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, EXPR_NODE_ID EXPR_NODE_ID, EXPRESS_ID EXPRESS_ID, SEQ_NBR SEQ_NBR, ITEM_TYPE_ID ITEM_TYPE_ID, PS_NODE_ID PS_NODE_ID, ITEM_ID ITEM_ID, FILTER_SET_ID FILTER_SET_ID, GRID_COL_ID GRID_COL_ID, EXPR_PARENT_ID EXPR_PARENT_ID, PROPERTY_ID PROPERTY_ID, COMPILE_ADVICE COMPILE_ADVICE, COL COL, DATA_VALUE DATA_VALUE, FIELD_NAME FIELD_NAME, EXPR_TYPE EXPR_TYPE, EXPR_SUBTYPE EXPR_SUBTYPE, TOKEN_LIST_SEQ TOKEN_LIST_SEQ, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, DELETED_FLAG DELETED_FLAG, EFF_FROM EFF_FROM, EFF_TO EFF_TO, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, SECURITY_MASK SECURITY_MASK, EFF_MASK EFF_MASK, CHECKOUT_USER CHECKOUT_USER, CONSEQUENT_FLAG CONSEQUENT_FLAG, MODEL_REF_EXPL_ID MODEL_REF_EXPL_ID, RULE_ID RULE_ID, TEMPLATE_ID TEMPLATE_ID, ARGUMENT_SIGNATURE_ID ARGUMENT_SIGNATURE_ID, ARGUMENT_INDEX ARGUMENT_INDEX, PARAM_SIGNATURE_ID PARAM_SIGNATURE_ID, PARAM_INDEX PARAM_INDEX, ARGUMENT_NAME ARGUMENT_NAME, DATA_TYPE DATA_TYPE, DISPLAY_NODE_DEPTH DISPLAY_NODE_DEPTH, COLLECTION_FLAG COLLECTION_FLAG, SOURCE_OFFSET SOURCE_OFFSET, SOURCE_LENGTH SOURCE_LENGTH, RELATIVE_NODE_PATH RELATIVE_NODE_PATH, MUTABLE_FLAG MUTABLE_FLAG, EVENT_EXECUTION_SCOPE EVENT_EXECUTION_SCOPE, DATA_NUM_VALUE DATA_NUM_VALUE, SEEDED_FLAG SEEDED_FLAG, ZD_EDITION_NAME ZD_EDITION_NAME from "CZ"."CZ_EXPRESSION_NODES"

View Text - HTML Formatted

SELECT LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, EXPR_NODE_ID EXPR_NODE_ID
, EXPRESS_ID EXPRESS_ID
, SEQ_NBR SEQ_NBR
, ITEM_TYPE_ID ITEM_TYPE_ID
, PS_NODE_ID PS_NODE_ID
, ITEM_ID ITEM_ID
, FILTER_SET_ID FILTER_SET_ID
, GRID_COL_ID GRID_COL_ID
, EXPR_PARENT_ID EXPR_PARENT_ID
, PROPERTY_ID PROPERTY_ID
, COMPILE_ADVICE COMPILE_ADVICE
, COL COL
, DATA_VALUE DATA_VALUE
, FIELD_NAME FIELD_NAME
, EXPR_TYPE EXPR_TYPE
, EXPR_SUBTYPE EXPR_SUBTYPE
, TOKEN_LIST_SEQ TOKEN_LIST_SEQ
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, DELETED_FLAG DELETED_FLAG
, EFF_FROM EFF_FROM
, EFF_TO EFF_TO
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, SECURITY_MASK SECURITY_MASK
, EFF_MASK EFF_MASK
, CHECKOUT_USER CHECKOUT_USER
, CONSEQUENT_FLAG CONSEQUENT_FLAG
, MODEL_REF_EXPL_ID MODEL_REF_EXPL_ID
, RULE_ID RULE_ID
, TEMPLATE_ID TEMPLATE_ID
, ARGUMENT_SIGNATURE_ID ARGUMENT_SIGNATURE_ID
, ARGUMENT_INDEX ARGUMENT_INDEX
, PARAM_SIGNATURE_ID PARAM_SIGNATURE_ID
, PARAM_INDEX PARAM_INDEX
, ARGUMENT_NAME ARGUMENT_NAME
, DATA_TYPE DATA_TYPE
, DISPLAY_NODE_DEPTH DISPLAY_NODE_DEPTH
, COLLECTION_FLAG COLLECTION_FLAG
, SOURCE_OFFSET SOURCE_OFFSET
, SOURCE_LENGTH SOURCE_LENGTH
, RELATIVE_NODE_PATH RELATIVE_NODE_PATH
, MUTABLE_FLAG MUTABLE_FLAG
, EVENT_EXECUTION_SCOPE EVENT_EXECUTION_SCOPE
, DATA_NUM_VALUE DATA_NUM_VALUE
, SEEDED_FLAG SEEDED_FLAG
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "CZ"."CZ_EXPRESSION_NODES"