Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    Mars
    Posts
    115

    Unanswered: Data to text file Urgent!!!

    Hi All,

    oracle 8.0.6.0.0
    sunsolaris

    How can i put the data of a particular table to a text file. the table has a column
    which has long data type.
    iam using oracle 8.0.6.0.0 on sunsolaris

    Pls help me in this

    Regards
    Adil

  2. #2
    Join Date
    Jan 2004
    Posts
    492

    Re: Data to text file Urgent!!!

    Originally posted by aadil
    Hi All,

    oracle 8.0.6.0.0
    sunsolaris

    How can i put the data of a particular table to a text file. the table has a column
    which has long data type.
    iam using oracle 8.0.6.0.0 on sunsolaris

    Pls help me in this

    Regards
    Adil

    Either spool the results to a file in SQL*PLUS or use the UTL_FILE package. UTL_FILE can only write out files to the Oracle server, and you must have a proper directory and priveleges set up.

Posting Permissions

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