1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to write the output from a plsql block (many columns) to a file

Discussion in 'SQL PL/SQL' started by prasanna.m, Oct 3, 2011.

  1. prasanna.m

    prasanna.m Guest

    File hadling in pl/sql

    HI everybody,

    I have got the answer how to write in to and read from a file (a line of text)through pl/sql using utl_fike package, but I want to know how to write the output from a plsql block (many columns) to a file. Please help me

    Thanks & Regards
    Prasanna
     
  2. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    Re: File hadling in pl/sql

    Still you can use the UTL_FILE package to write output from PL/SQL block to afile.