DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    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
    Helsinki. Finland
    Spool it in SQL*Plus:

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

    In SQL*Plus type:

    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.