Toad World® Forums

Can you export a list of all packages

In an effort to create an inventory and source collection for all packages,
procedures etc within TOAD databases, I am wondering if there is a way in which
I could export a list of all items( pkgs, sprocs etc) rather than creating a
handwritten list?

Why not query the system tables?

SELECT
owner,
object_name,
object_type,
created,
last_ddl_time,
status
FROM sys.ALL_OBJECTS

To remove the system, itself, add a WHERE clause along the lines of :
OWNER NOT IN (‘SYS’, ‘PUBLIC’, ‘SYSTEM’, . . .)

For the objects in a specific schema:
OWNER = ‘’

You could spool the SQL from TOAD, itself, and use that SQL to generate your
lists.

Ray Paschke
System Analyst
Federal Home Loan Bank of Pittsburgh
Desk: 412-288-5548
Cell: 412-260-7026

Loralei
Sent by: toad@yahoogroups.com

11/23/2011 02:41 PM

Please respond to
toad@yahoogroups.com

To

"toad@yahoogroups.com"

cc

Subject

[toad] Can you export a list of all packages

In an effort to create an inventory and source collection for all packages,
procedures etc within TOAD databases, I am wondering if there is a way in which
I could export a list of all items( pkgs, sprocs etc) rather than creating a
handwritten list?

OWNER NOT IN ( ‘SYS’ , ‘PUBLIC’

Keep in mind that if you’ve created public synonyms (or other such objects
you want to list), you’ll have to alter your query accordingly.

Roger S.

Thank you…( brain fade here evidently!)

And always remember…when life hands you Lemons, ask for tequila and salt and
call me over

Loralei writes:

And always remember…when life hands you Lemons, ask for tequila and salt
and call me over

Now THAT’s a disclaimer I can understand. Well done!

Happy Thanksgiving to all the US folk!

Rich – [TeamT]

Disclaimer: GO PACK GO!

It is my opinion your work, and web-site, are marvelous.

Plumbing Duncanville
Paterson Plumbing
plumber West New York
New Britain Plumbing

It is my opinion your work, and web-site, are marvelous.

List of 4 plumbing sites I won’t repeat

It appears the spammers are attempting to be more subtle by offering flattery in
exchange for the unsolicited advertising.

Of course… I could be mistaken. The particular company could just have the
4 sites as an automatic part of the email and they really are a customer of
Quest. In that case, my apologies for misunderstanding the intent of the
message.

Roger S.