Re: RE: Dba tools on NT

Hello Jared

I do not know Perl but it seems to me that your script will put a comma (',')
before the first value, which will add a first blank column on input.

Feel free to correct me if I am wrong but do not RTFM because I do not have the manuals.

Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Thursday, August 15, 2002 8:53 AM

>
> Rachel,
>
> This snippet is reading data from a previously opened
> handle to a table. The 'print' statement prints a quote,
> the contents of the array ref $ary delimited with ",", and
> closes with quote and a newline.
>
> Maybe not readable if you've never programmed in Perl,
> but pretty simple stuff with a little experience.
>
> Jared
>
> On Wednesday 14 August 2002 18:23, Rachel Carmichael wrote:
> > readable. uh huh. sure
> >
> > how does this create a csv file?
> >
> > --- Jared.Still_at_radisys.com wrote:
> > > 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
> > >
> > >
> > >
> > >
> > >
> > > "Grabowy, Chris" <cgrabowy_at_fcg.com>
> > > Sent by: root_at_fatcity.com
> > > 08/14/2002 07:28 AM
> > > Please respond to ORACLE-L
> > >
> > >
> > > To: Multiple recipients of list ORACLE-L
> > > <ORACLE-L_at_fatcity.com>
> > > cc:
> > > Subject: RE: RE: Dba tools on NT
> > >
> > >
> > > Spaghetti code is easy to write...just throw some GOTOs in there.
> > >
> > > I just have some issues with a language that has more special
> > > characters
> > > in
> > > it then alpha characters.
> > >
> > > Sigh. I miss the good ole days, COBOL, Fortran, Pascal, and even a
> > > little
> > > bit of BASIC...I guess that's why I enjoy PL/SQL.
> > >
> > > -----Original Message-----
> > > Sent: Tuesday, August 13, 2002 5:32 PM
> > > To: Grabowy, Chris; Multiple recipients of list ORACLE-L
> > >
> > >
> > > I'll agree with Jared. Given any programming or scripting language
> > > and
> > > there's
> > > some duhveloper out there who can make a completely obfuscated mess
> > > out of
> > > it.
> > > I was once told that it was impossible under Ada, boy did that ever
> > > get
> > > retracted by the author in a hurry!!
> > >
> > > Dick Goulet
> > >
> > > ____________________Reply Separator____________________
> > > Author: "Grabowy; Chris" <cgrabowy_at_fcg.com>
> > > Date: 8/13/2002 2:06 PM
> > >
> > > DOH!!!! Ouch...(limping along)...come on now. Perl has won "awards"
> > > for
> > > it's "readability" and "maintainability". I'm not slamming Perl, it
> > > has
> > > saved my behind on W2K platforms, which has no real scripting
> > > language.
> > > And
> > > I did advance order a copy of your book. Not that I want to be a
> > > Duhveloper...
> > >
> > >
> > >
> > > -----Original Message-----
> > > Sent: Tuesday, August 13, 2002 4:42 PM
> > > To: ORACLE-L_at_fatcity.com
> > > Cc: Grabowy, Chris
> > >
> > > > And it's difficult to write, looks like scrambled eggs when your
> > >
> > > done,
> > > and
> > >
> > > > impossible to maintain...
> > >
> > > Of course, you can say this about any programming or scripting
> > > language.
> > >
> > > It all depends on the ability of the programmer.
> > >
> > > Jared
> > >
> > >
> > >
> > >
> > >
> > >
> > > "Grabowy, Chris" <cgrabowy_at_fcg.com>
> > > Sent by: root_at_fatcity.com
> > > 08/13/2002 10:24 AM
> > > Please respond to ORACLE-L
> > >
> > >
> > > To: Multiple recipients of list ORACLE-L
> > > <ORACLE-L_at_fatcity.com>
> > > cc:
> > > Subject: RE: Dba tools on NT
> > >
> > >
> > > And it's difficult to write, looks like scrambled eggs when your
> > > done, and
> > > impossible to maintain...
> > >
> > > On the other hand, you could write the entire Windows XP operating
> > > system
> > > in
> > > one line of Perl...including Internet Explorer.
> > >
> > > -----Original Message-----
> > > Sent: Tuesday, August 13, 2002 12:49 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Without a doubt - perl - get it free from www.activestate.com. Why
> > > use it?
> > > Well, it is so flexible compared to other NT/DOS scripting tools
> > > you'll
> > > wonder why you never had it before! It's also portable meaning all
> > > those
> > > scripts you write should work on multi platforms with just a little
> > > tweak!
> > >
> > > Lewis Bishop
> > > ---
> > > Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant
> > > Phone - 020 8298 3418
> > > Mobile - 07950 380857
> > > Email - lewis.bishop_at_woolwich.co.uk
> > >
> > >
> > > -----Original Message-----
> > > Sent: 13 August 2002 17:25
> > > To: Multiple recipients of list ORACLE-L
> > >
> > > This header confirms that this email message has been swept for the
> > > presence of computer viruses.
> > >
> > > Corporate IT
> > > THE WOOLWICH
> >
> > ----------------------------------------------------------------------
> >
> > > Hello all
> > >
> > > We are looking on programming and scripting tools
> > > for DBA team on NT.
> > >
> > > Can you, oracle DBA's on NT, tell me off the list
> > > what tools you are using for these functions
> > > and, if you be so kind, why you choose them.
> > >
> > > TIA
> > >
> > > Yechiel Adar
> > > Mehish
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Yechiel Adar
> > > INET: adar76_at_inter.net.il
> > >
> > > 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).
> > >
> > >
> > > The information, attachments and opinions contained in this message
> > > are
> > > those of its author only and do not necessarily represent those of
> > > The
> > > Woolwich and or any other members of the Barclays Group and are
> > > intended
> > > solely for the use of the individual or entity to whom they are
> > > addressed.
> > > The sender may not be authorised to give financial advice, and
> > > nothing in
> > > this message should be construed as offering such advice.
> > >
> > > The message may contain privileged and confidential information and
> > > you
> > > may
> > > not copy, distribute or take any action in reliance on it. If you
> > > have
> > > received this email in error please notify the Information Security
> > > Manager
> > > at ADMINISTRATOR_at_WOOLWICH.CO.UK
> > >
> > > Replies to this email may be monitored for operational or business
> >
> > === message truncated ===
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > HotJobs - Search Thousands of New Jobs
> > http://www.hotjobs.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jared Still
> INET: jkstill_at_cybcon.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yechiel Adar
  INET: adar76_at_inter.net.il

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).