select '1','0',
p.xdsid#,
(select name from xs$obj where id = p.xdsid#),
(select owner from xs$obj where id = p.xdsid#),
p.pname,
p.type
from xs$policy_param p
View Text - HTML Formatted
SELECT '1' , '0' ,
P.XDSID# ,
(SELECT NAME FROM XS$OBJ WHERE ID = P.XDSID#) ,
(SELECT OWNER FROM XS$OBJ WHERE ID = P.XDSID#) ,
P.PNAME ,
P.TYPE
FROM XS$POLICY_PARAM P