갈루아의 반서재

728x90

SELECT tri.trigger_name triggername, tri.status status, obj.status validation, tri.table_name tablename, tri.table_owner owner

FROM SYS.ALL_OBJECTS obj, SYS.ALL_TRIGGERS tri

WHERE tri.owner = '        '

 AND obj.object_type   = 'TRIGGER'

 AND obj.object_name   = tri.trigger_name

 AND obj.owner         = tri.owner

tri.owner 에 오너 이름 넣고 조회하면 됨.









728x90