LuKKa wrote:Handle: LuKKa
How can I know that a table is using in any packege or procedure or function ?
I mean , let say I have 10 Packages , 10 Procedures and 5 Functions .
I need to know in which Packages , Procedures or Functions are using the table EMP .
How can I search ? Is there any command or I need to open all the procedures and then search one by one ?
another false positive for EMP
/* select count(*) into foo from EMP */
you'd miss EMP if FOOBAR is a synonym for EMP or a view that uses EMP
select count(*) from employees EMP
false positive again
select count(*) from FOOBAR;
and so on...
declare EMP number;