DBA Data[Home] [Help]

VIEW: CTXSYS.DRV$USER_EXTRACT_STOP_ENTITY

Source

View Text - Preformatted

select "ESE_POL_ID","ESE_NAME","ESE_TYPE","ESE_STATUS","ESE_COMMENTS" from dr$user_extract_stop_entity
where ese_pol_id = SYS_CONTEXT('DR$APPCTX', 'IDXID')
with check option
View Text - HTML Formatted

SELECT "ESE_POL_ID"
, "ESE_NAME"
, "ESE_TYPE"
, "ESE_STATUS"
, "ESE_COMMENTS"
FROM DR$USER_EXTRACT_STOP_ENTITY WHERE ESE_POL_ID = SYS_CONTEXT('DR$APPCTX'
, 'IDXID') WITH CHECK OPTION