Skip to Main Content
Forums

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!

How to know database name and schema name by providing package name?

DeshmukhPJan 22 2014 — edited Jan 22 2014

Hi,

Could someonw will help me to get database name and schema name by providing package name ?

I have used the query : select * from all_objects where object_name='Package_name'; but it simply returns schema name where as i need DB name and username.

--Prajakta
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 19 2014
Added on Jan 22 2014
10 comments
9,972 views