Home » Other » Client Tools » Looking for a TOAD forum
Looking for a TOAD forum [message #178271] Tue, 20 June 2006 07:23 Go to next message
bobk544
Messages: 1
Registered: June 2006
Junior Member
Hello,

Can anyone recommend a farily active TOAD forum please?

I basically need help in writing a series of scripts that will extract sample data from about 150 Oracle tables and then copy/format the table data into an Excel spreadsheet, 1 spreadhseet per table.

I could do this manually of course, but it's very tedious and error prone and we may be changing instances at any time, so i'll have to do it all over again!

Or another thought is, maybe there is an Oracle utility that i can write that will do the same thing?

Thanks very much for any insights!
BobK
Re: Looking for a TOAD forum [message #178273 is a reply to message #178271] Tue, 20 June 2006 07:29 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You can do this with just some native sql and sql*plus commands. But it ***depends*** on your level of comfort with the said utility.
Tom Kyte has some cool scripts that makes things much easier.
With a little tweak, you can get what you want.
http://asktom.oracle.com/~tkyte/flat/index.html
Re: Looking for a TOAD forum [message #178371 is a reply to message #178271] Tue, 20 June 2006 19:31 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Start at the TOAD website. http://www.quest-pipelines.com/pipelines/dba/index.asp

David
Previous Topic: PL SQL Developer 7 and Oracle 10g
Next Topic: how to connect database through toad
Goto Forum:
  


Current Time: Sun Dec 22 20:15:21 CST 2024