nowhen_trigger.sql

来自「OReilly Oracle PL SQL Programming第4版源代码」· SQL 代码 · 共 8 行

SELECT *
  FROM user_triggers tr
 WHERE when_clause IS NULL AND 
       EXISTS (SELECT 'x'
                 FROM user_trigger_cols
                WHERE trigger_owner = USER
			    AND trigger_name = tr.trigger_name);