readable out data from table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: readable out data from table

  1. #1
    Join Date
    Apr 2001
    Posts
    151
    Hi all,

    How can I export data from 1 table to .txt or .xls file? I know exp/imp won't do it.
    Thanks,
    Elin@trend

  2. #2
    Join Date
    Jul 2000
    Posts
    521
    You can write a SQL query that will dump the data in required format.
    svk

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Write a small plsql script using the utl_file.
    http://technet.oracle.com/docs/produ...ile.htm#998101

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  4. #4
    Join Date
    Apr 2001
    Posts
    151

    Angry

    Can some one give me an example, I need results from

    select * from emp;

    into a .txt file or .csv file

    Parameter UTL_FILE_DIR not set up in iniPROD.ora yet. Is there a way to work around?

    Ergent, please help.

    Elin@trend

  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    what is your OS?

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  6. #6
    Join Date
    Mar 2001
    Posts
    26
    spool c:\documents\emp.txt

    select * from emp;

    spool off

  7. #7
    Join Date
    Apr 2001
    Posts
    151
    NT-sp6a
    Elin@trend

Posting Permissions

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


Click Here to Expand Forum to Full Width