Re: Text file from store procedure

> @list= reverse sort { -M $a <=> -M $b } @list;

Which by itself is enough to make it worth learning.

Jared

On Wed, 2003-08-20 at 19:49, Mladen Gogala wrote:
> If you are really brave, you can write stored procedures in the favorite
> language of Mr. Cary Milsap and the list owner, the only language that
> will take a syntax like this:
>
> @list= reverse sort { -M $a <=> -M $b } @list;
>
> The URL can be found at: http://www.smashing.org/extproc_perl
>
> Not only it is possible to write to files, you can even format it into
> multi-line fields, you can have page headers, repeating after every $=
> lines. You can do marvelous things with strings and a whole lot of other
> things. Standard for accessing the database is described in the O'Reilly
> "cheetah" book named "Programming the Perl DBI" writen by Crocodile Descartes
> and Tim Bunce (ISBN:1-56592-699-4)
>
>
>
> On 2003.08.20 22:04, Richard Ji wrote:
> > You can also use Java Stored Procedures.
> >
> >
> > -----Original Message-----
> > From: Steve McClure [mailto:smcclure_at_usscript.com]
> > Sent: Wed 8/20/2003 8:44 PM
> > To: Multiple recipients of list ORACLE-L
> > Cc:
> > Subject: RE: Text file from store procedure
> > You can spool output to the location of your choice in sqlplus. Forms
> > allows you to use a utl_file like procedure called 'text_io' I believe. In
> > 6i the output is written to the client machine, in 9i the results are
> > written to the app server.
> >
> > Why don't you want to use utl_file? It is designed to create and write text
> > files from PL/SQL blocks.
> >
> > -----Original Message-----
> > Hamid Alavi
> > Sent: Wednesday, August 20, 2003 4:19 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > List of guru,
> >
> > Is any body know how can I create a text file from store procedure without
> > using utl_file , I want to create & write a text file from result of a
> > select statement and write the result as a text file in a define directory.
> > Thanks for your help.
> >
> >
> > Hamid Alavi
> >
> > Office : 818-737-0526
> > Cell phone : 818-416-5095
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Hamid Alavi
> > INET: hamid.alavi_at_quovadx.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Steve McClure
> > INET: smcclure_at_usscript.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> >
> >
> >
>
> --
> Mladen Gogala
> Oracle DBA
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mladen Gogala
> INET: mgogala_at_adelphia.net
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).