DBA Data[Home] [Help]

VIEW: SYS.V_$AQ_NONDUR_REGISTRATIONS

Source

View Text - Preformatted

select "REG_ID","SUBSCRIPTION","LOCATION","USER#","USER_CONTEXT","CONTEXT_SIZE","NAMESPACE","VERSION","STATE","QOS","REG_TIME","CON_ID" from v$aq_nondur_registrations
View Text - HTML Formatted

SELECT "REG_ID"
, "SUBSCRIPTION"
, "LOCATION"
, "USER#"
, "USER_CONTEXT"
, "CONTEXT_SIZE"
, "NAMESPACE"
, "VERSION"
, "STATE"
, "QOS"
, "REG_TIME"
, "CON_ID"
FROM V$AQ_NONDUR_REGISTRATIONS