DBA Data[Home] [Help]

VIEW: SYS.DBA_SQLSET_REFERENCES

Source

View Text - Preformatted

select d.name as sqlset_name, d.owner as sqlset_owner, r.sqlset_id,
         r.id, r.owner, r.created, r.description
  from   WRI$_SQLSET_DEFINITIONS d, WRI$_SQLSET_REFERENCES r
  where  d.id = r.sqlset_id
View Text - HTML Formatted

SELECT D.NAME AS SQLSET_NAME
, D.OWNER AS SQLSET_OWNER
, R.SQLSET_ID
, R.ID
, R.OWNER
, R.CREATED
, R.DESCRIPTION
FROM WRI$_SQLSET_DEFINITIONS D
, WRI$_SQLSET_REFERENCES R
WHERE D.ID = R.SQLSET_ID