SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

List of Tables not being used in any Stored Proc

Badam123Jul 13 2017 — edited Jul 17 2017

Identify the list of all tables ( user_tables) which are not used in any of the Stored procedure ( user_source ).

By Stored proc I mean Package, Procedure,Fucntions.

Below query is not working:

select * from user_tables A where not exists

( select 1 from user_source B where A.table_name like upper('%B.text%') );

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 14 2017

Added on Jul 13 2017

#sql

12 comments

920 views