Export oracle table to text file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Export oracle table to text file

Hybrid View

  1. #1
    Join Date
    Oct 2002
    Posts
    1
    I want to export some tables from Oracle Database to delimited Text file.

    I try with SQL*Loader ... I didn't know how to use it for this issue.

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Spool it in SQL*Plus:

    Say the table is called EMP and has three columns: id, name, start_date.

    In SQL*Plus type:

    Code:
    spool c:\temp\emp.lis
    select id||';'||name||';'||to_char(start_date,'dd.mm.yyyy') from EMP;
    spool off
    The text file is in c:\temp.



    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

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