CODEWITHSUNDEEP
sqloracle-databaseexporttoad
SuperPowerUser
SuperPowerUser

Reputation: 31

How to export the data in one go in Toad for Oracle? (without first running it to display the data)

I want to export/extract the results of the query at once, without running the query first and only then after getting the result. How can I do it?

Upvotes: 3

Views: 30251

Answers (3)

Andrea
Andrea

Reputation: 12355

If you want to achieve this using Toad:

  1. right click on table name
  2. select "Export Data" from context menu
  3. write "where" statement of your export query
  4. select destination (clipboard/file)
  5. click "ok"

Upvotes: 3

the_slk
the_slk

Reputation: 2182

You can write a script that will be run from the command line (Linux/Windows) and redirect the output (using ">" sign) to a file. Still you have to know how to use SQL*PLUS...

Upvotes: 3

David Jashi
David Jashi

Reputation: 4511

Use SPOOL directive to output results directly to file. This will work in plain SQLPLUS also.

Upvotes: 1

Related Questions