DBA Data[Home] [Help]

VIEW: IEM.IEM_SAFETY_QUEUES#

Source

View Text - Preformatted

select MESSAGE_ID MESSAGE_ID, MESSAGE_SIZE MESSAGE_SIZE, SENDER_NAME SENDER_NAME, USER_NAME USER_NAME, DOMAIN_NAME DOMAIN_NAME, MESSAGE_PRIORITY MESSAGE_PRIORITY, MSG_STATUS MSG_STATUS, SUBJECT SUBJECT, CLASSIFICATION CLASSIFICATION, SCORE SCORE, SENT_DATE SENT_DATE, CUSTOMER_ID CUSTOMER_ID, PRODUCT_ID PRODUCT_ID, KEY1 KEY1, VALUE1 VALUE1, KEY2 KEY2, VALUE2 VALUE2, KEY3 KEY3, VALUE3 VALUE3, KEY4 KEY4, VALUE4 VALUE4, KEY5 KEY5, VALUE5 VALUE5, KEY6 KEY6, VALUE6 VALUE6, KEY7 KEY7, VALUE7 VALUE7, KEY8 KEY8, VALUE8 VALUE8, KEY9 KEY9, VALUE9 VALUE9, KEY10 KEY10, VALUE10 VALUE10, SECURITY_GROUP_ID SECURITY_GROUP_ID from "IEM"."IEM_SAFETY_QUEUES"
View Text - HTML Formatted

SELECT MESSAGE_ID MESSAGE_ID
, MESSAGE_SIZE MESSAGE_SIZE
, SENDER_NAME SENDER_NAME
, USER_NAME USER_NAME
, DOMAIN_NAME DOMAIN_NAME
, MESSAGE_PRIORITY MESSAGE_PRIORITY
, MSG_STATUS MSG_STATUS
, SUBJECT SUBJECT
, CLASSIFICATION CLASSIFICATION
, SCORE SCORE
, SENT_DATE SENT_DATE
, CUSTOMER_ID CUSTOMER_ID
, PRODUCT_ID PRODUCT_ID
, KEY1 KEY1
, VALUE1 VALUE1
, KEY2 KEY2
, VALUE2 VALUE2
, KEY3 KEY3
, VALUE3 VALUE3
, KEY4 KEY4
, VALUE4 VALUE4
, KEY5 KEY5
, VALUE5 VALUE5
, KEY6 KEY6
, VALUE6 VALUE6
, KEY7 KEY7
, VALUE7 VALUE7
, KEY8 KEY8
, VALUE8 VALUE8
, KEY9 KEY9
, VALUE9 VALUE9
, KEY10 KEY10
, VALUE10 VALUE10
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "IEM"."IEM_SAFETY_QUEUES"