> @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:[EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).