Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2012
    Posts
    1

    Unanswered: export data to csv file

    how to create a procedure to read data from plsql database and export it to csv file without using sys_utl and by using dbms_output.put_line();

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    post URL that documents "plsql database" because I don't know what that is.
    PL/SQL is a procedural programming language owned by Oracle.
    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.

  3. #3
    Join Date
    Oct 2002
    Location
    Cape Town, South Africa
    Posts
    253
    This link:
    Simplest example of writing to MS Excel using an Oracle Stored Procedure, shows how to output a csv.

    You will not need any of the Oracle directory stuff, and you will replace all the utl_file.put_line commands with your dbms_output.put_line commands.

    Something to bare in mind: DBMS_OUTPUT has a line length limit, which you are most likely going to hit; unless your CSV is going to be quite "narrow".

Posting Permissions

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