Hi all,
Before dropping a column, I need to check if it's used in any stored procedure. How can I do it with a sql request ? (Oracle 9i)
Thanks
Printable View
Hi all,
Before dropping a column, I need to check if it's used in any stored procedure. How can I do it with a sql request ? (Oracle 9i)
Thanks
You can check dependencies at the table level by querying DBA_DEPENDENCIES, for example with a script like deps.sql.