Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Location
    Bangalore, India
    Posts
    4

    Unhappy Unanswered: select into a outfile

    Hi,

    I am new to oracle. I have worked on mysql.
    Can you please tell me how to write the following in oracle?

    select fieldx from tablex into OUTFILE ?c:\data.txt?;"

    Please help

    regards,
    ch

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    > spool c:\data.txt
    > select fieldx from tablex;
    > spool off

    Output goes to screen and into the file.

Posting Permissions

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