Results 1 to 3 of 3

Thread: Oracle to CSV

  1. #1
    Join Date
    Oct 2003
    Location
    Mumbai,India.
    Posts
    36

    Unanswered: Oracle to CSV

    Hi friends,
    How to export the oracle table data into a newly created CSV file, Using sql*loader/Toad Software?
    Is it possible to write a ctrl file to do this?
    Please help me to resolve this problem.
    Thanks for your time.

  2. #2
    Join Date
    Oct 2003
    Posts
    26
    You do not need a control file to save the data in table in a flat file in csv format

    I suggest you use Toad to achieve your need

    From the TOAD sql window, select the records that you want & from the TOAd menu, click on Export & specify "," as the delimiter.

    HTH
    Arvind

  3. #3
    Join Date
    Oct 2003
    Location
    Mumbai,India.
    Posts
    36
    Thank you very much.It's woriking.
    Thanks for your time.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •