2009/03/17

如何查詢Oracle Table有哪些Trigger

有許多的工具如Tod, Navigator可以透過功能查詢 但Oracle可以很方便的透過SQL的查詢即可查到 SELECT * FROM all_triggers at WHERE at.table_name = upper('ap_invoice_lines_all');

No comments: