Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2013
    Posts
    6

    Unanswered: Creating csv file in Oracle

    Is it possible to create a csv file using command line but not using any tools.

  2. #2
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    Which command line? DOS? Linux? SQL?
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  3. #3
    Join Date
    Sep 2013
    Posts
    6
    in DOS for Oracle

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Quote Originally Posted by santasammy View Post
    Is it possible to create a csv file using command line but not using any tools.

    SQL*Plus can make csv file
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Sep 2013
    Posts
    6
    pls provide an example so that i can test it also...because its going to be part of a batch file.

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    sqlplus scott/tiger
    set colsep ,
    spool emp.csv
    select * from emp;
    spool off
    exit
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by santasammy View Post
    in DOS for Oracle
    Oracle does not support DOS - there is no Oracle client that runs under DOS.
    There was one back in the 80s where DOS was actually used, but today there is definitely no Oracle client for DOS.
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

Posting Permissions

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