Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    Unanswered: Help with Data Export.

    hi,

    I want to get data from a table in an oracle 9i database into a flat file. I am able to export the same to a Tab Delimited file using Toad.

    Any one has clues how can i specify a delimiter preferably a , when i export the same using TOAD.

    Any clues will be helpful.

    TIA
    HTH

    Nitin

    Ask the experienced rather than the learned

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Depending on the data ... you can run SQLPlus and spool output to a file ...
    ie:

    set linesize 120
    set header off
    set pagesize 0
    set feedback off
    set trimspool on

    spool c:\test.txt

    select username||chr(9)||sid||chr(9)||serial#||chr(9)||pr ogram from v$session;

    spool off

    HTH
    Gregg

Posting Permissions

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