Oracle Database search Stored Procedure

1. Select name, type from SYS. all_source
Where instr (upper (text), 'tbname')> 0
2. Select name, type from user_dependencies where referenced_name = upper ('tablename ');
3. <PL/SQL developer has the find dB objedts function, which can meet the requirements, but retrieval is slow. If there are many stored procedures, views, triggers, and functions, You need to be patient.>

Dynamically input a table name and create a new table in the Stored Procedure
Create or replace procedure AAA (name in varchar2)
Is
Begin
Declare
Sqlstrvarchar2 (2000 );
Begin
Sqlstr: = 'create table | 'temptable' |
(
A varchar (30 ),
B varchar (50)
)';

Execute immediate sqlstr;
End;
End;