Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: Dba tools on NT

RE: RE: Dba tools on NT

From: Straub, Dan <Dan.Straub_at_McKesson.com>
Date: Wed, 14 Aug 2002 22:03:18 -0800
Message-ID: <F001.004B5994.20020814220318@fatcity.com>


Stay on the good side Jared. Your code snippet looks great to me, and looking at it finally showed me a clear example of how that q{} thingy works. I write a lot of Oracle utility type stuff that has to run on both Windows and UNIX. Perl does the job every time.

Rachel, Jared should admit that he would probably need just a few more characters (about 6 alpha and 48 special!) to actually run the code, but the essence is there and with a glance you can tell that it does produce CSV output using DBI/DBD to access the database.

:)

Dan.

"There are only 10 types of people in the world: Those who understand binary, and those who don't."

-----Original Message-----
]
Sent: Wednesday, August 14, 2002 8:38 PM To: Multiple recipients of list ORACLE-L

How many developers can maintain that "cryptic" Perl code?

Come over to the light...don't be afraid.

Chris

PS. 20 alpha characters...and about 25 special characters in that bit of
code.....hmmmmm, not going to say anything about that.

-----Original Message-----
To: ORACLE-L_at_fatcity.com
Cc: Grabowy, Chris
Sent: 8/14/2002 2:03 PM

How many of those "non-cryptic" languages can dump a table to a CSV file in 2 lines of (readable ) code?

   while ( my $ary = $sth->fetchrow_arrayref ) {

      print q{"} . join(q{","},@{$ary}) . qq{"\n};    }

Come over to the dark side Chris. ;)

Jared

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Straub, Dan
  INET: Dan.Straub_at_McKesson.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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). Received on Thu Aug 15 2002 - 01:03:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US