VIEW: SYS.USER_SQLSET_REFERENCES

Source

View Text - Preformatted

select d.name as sqlset_name,
         r.sqlset_id, r.id, r.owner, r.description, r.created
  from   wri$_sqlset_definitions d, wri$_sqlset_references r
  where d.id=r.sqlset_id and (d.owner = SYS_CONTEXT('USERENV', 'CURRENT_USER')
                          or  r.owner = SYS_CONTEXT('USERENV', 'CURRENT_USER'))

View Text - HTML Formatted

SELECT D.NAME AS SQLSET_NAME
, R.SQLSET_ID
, R.ID
, R.OWNER
, R.DESCRIPTION
, R.CREATED
FROM WRI$_SQLSET_DEFINITIONS D
, WRI$_SQLSET_REFERENCES R
WHERE D.ID=R.SQLSET_ID
AND (D.OWNER = SYS_CONTEXT('USERENV'
, 'CURRENT_USER') OR R.OWNER = SYS_CONTEXT('USERENV'
, 'CURRENT_USER'))