select category_id,
name,
agency,
version,
URI
from MGD_IDENCODING_category_tab
where owner = 'MGDSYS' or
owner = sys_context('userenv', 'SESSION_USER')
View Text - HTML Formatted
SELECT CATEGORY_ID ,
NAME ,
AGENCY ,
VERSION ,
URI
FROM MGD_IDENCODING_CATEGORY_TAB
WHERE OWNER = 'MGDSYS' OR
OWNER = SYS_CONTEXT('USERENV' , 'SESSION_USER')