Re: Find a table name for user packages..

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 13 May 2005 06:23:56 +0200
Message-ID: <42842b96$0$308$636a15ce@news.free.fr>

"e01osama" <mmnanuruddha_at_gmail.com> a écrit dans le message de news:1115956602.334392.260400_at_g49g2000cwa.googlegroups.com...
| hi........
|
| i have installed oracle 9i, i need to fine a table name..
| I think there should be table for that also..
| Problem is this....
| there are several user in database. like SYS,sysman...
| then each user have own packages,and own procedures. then this package
| names and procedure names should be in a table.. i need to know what is
| that table name. an d hoe i can retrive those vales from them..like
| select Package_name from XXX table user_name=SYS......
|
| help meee..........
|

dba_objects, dba_source.
http://otn.oracle.com/pls/db92/db92.catalog_views?remark=homepage

Regards
Michel Cadot Received on Thu May 12 2005 - 23:23:56 CDT