Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE PROCEDURE GAT(
- tableName VARCHAR2
- )
- AS
- CURSOR allTriggers IS
- SELECT *
- FROM DBA_TRIGGERS
- WHERE TABLE_NAME = tableName;
- BEGIN
- DBMS_OUTPUT.PUT_LINE('COLUMN NAME | TRIGGER NAME');
- DBMS_OUTPUT.PUT_LINE('----------- + ------------');
- FOR idx IN allTriggers LOOP
- IF idx.COLUMN_NAME IS NULL
- THEN DBMS_OUTPUT.PUT('NULL ');
- ELSE DBMS_OUTPUT.PUT(idx.COLUMN_NAME);
- END IF;
- DBMS_OUTPUT.PUT(' | ');
- IF idx.TRIGGER_NAME IS NULL
- THEN DBMS_OUTPUT.PUT('NULL');
- ELSE DBMS_OUTPUT.PUT(idx.TRIGGER_NAME);
- END IF;
- DBMS_OUTPUT.NEW_LINE;
- END LOOP;
- END;
- /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement