check if column is created by trigger
Posted on 2012-04-11
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');