Jay Roy
asked on
check if column is created by trigger
hi
i want to know if the prod_id column in my Product table is being generated by a trigger.
I am using this sql but no luck. Any clue what i am doing wrong?
SELECT * FROM all_dependencies WHERE referenced_name = 'PRODUCT.PROD_ID' AND type IN ('PACKAGE BODY', 'PROCEDURE', 'FUNCTION', 'TYPE','TRIGGERS');
i want to know if the prod_id column in my Product table is being generated by a trigger.
I am using this sql but no luck. Any clue what i am doing wrong?
SELECT * FROM all_dependencies WHERE referenced_name = 'PRODUCT.PROD_ID' AND type IN ('PACKAGE BODY', 'PROCEDURE', 'FUNCTION', 'TYPE','TRIGGERS');
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
There is no 'TRIGGERS', change it to 'TRIGGER'.
Perhaps instead of looking at the actual trigger code, just query: DBA_TRIGGER_COLS...
:p
:p
ASKER
ok.
I assume i can use the same query
SELECT * FROM all_dependencies WHERE referenced_name = 'PRODUCT' AND type IN ('PACKAGE BODY', 'PROCEDURE', 'FUNCTION', 'TYPE','TRIGGERS');
which will give me references in triggers and other places.