select r.sname, r.oname, r.type, r.status, r.generation_status, r.id,
r.object_comment, r.gname, r.min_communication, r.trigflag,
r.internal_package_exists, r.gowner, r.nested_table
from repcat_repobject r, user_users u
where r.sname = u.username
and r.type != 'INTERNAL PACKAGE'
SELECT R.SNAME
, R.ONAME
, R.TYPE
, R.STATUS
, R.GENERATION_STATUS
, R.ID
,
R.OBJECT_COMMENT
, R.GNAME
, R.MIN_COMMUNICATION
, R.TRIGFLAG
,
R.INTERNAL_PACKAGE_EXISTS
, R.GOWNER
, R.NESTED_TABLE
FROM REPCAT_REPOBJECT R
, USER_USERS U
WHERE R.SNAME = U.USERNAME
AND R.TYPE != 'INTERNAL PACKAGE'
|
|
|