Advertisement
Guest User

Untitled

a guest
Sep 19th, 2019
122
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.72 KB | None | 0 0
  1. CREATE OR REPLACE PROCEDURE GAT(
  2. tableName VARCHAR2
  3. )
  4. AS
  5. CURSOR allTriggers IS
  6. SELECT *
  7. FROM DBA_TRIGGERS
  8. WHERE TABLE_NAME = tableName;
  9. BEGIN
  10. DBMS_OUTPUT.PUT_LINE('COLUMN NAME | TRIGGER NAME');
  11. DBMS_OUTPUT.PUT_LINE('----------- + ------------');
  12. FOR idx IN allTriggers LOOP
  13. IF idx.COLUMN_NAME IS NULL
  14. THEN DBMS_OUTPUT.PUT('NULL ');
  15. ELSE DBMS_OUTPUT.PUT(idx.COLUMN_NAME);
  16. END IF;
  17. DBMS_OUTPUT.PUT(' | ');
  18. IF idx.TRIGGER_NAME IS NULL
  19. THEN DBMS_OUTPUT.PUT('NULL');
  20. ELSE DBMS_OUTPUT.PUT(idx.TRIGGER_NAME);
  21. END IF;
  22. DBMS_OUTPUT.NEW_LINE;
  23. END LOOP;
  24. END;
  25. /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement