Something of my creation, OK I pilfered most of it, MANY years ago that got stuck into a C language library. Haven't modified it in years(1988) other than recompiling the library and it still works like a dream.
Dick Goulet ____________________Reply Separator____________________ Author: [EMAIL PROTECTED] Date: 8/15/2002 3:15 PM Dick, What is 'export_to_file'? Your own function, or something of Oracle's? Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/15/2002 08:03 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re[2]: RE: Dba tools on NT One of the things I love about doing C code is your ability to create libraries and/or DLL's on NT (.so files on Unix, which I haven't mastered yet). When one of our developers asked HOW DO I DO THIS some months ago, we wrote the following code: void main(int argc, char *argv[]) { char stmt[1000]; if(!logon(argv[1], argv[2], argv[3])) { printf("Cannot connect to database %s\n", argv[3]); exit(1); } sprintf(stmt, "SELECT * FROM %s\0", argv[5]); export_to_file(argv[4], stmt); logoff(1); exit(0); } Worked like a champ. Dick Goulet ____________________Reply Separator____________________ Author: Jared Still <[EMAIL PROTECTED]> Date: 8/14/2002 10:53 PM 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? > > --- [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 08/14/2002 07:28 AM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > 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" <[EMAIL PROTECTED]> > > 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: [EMAIL PROTECTED] > > 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" <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 08/13/2002 10:24 AM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > 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 - [EMAIL PROTECTED] > > > > > > -----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: [EMAIL PROTECTED] > > > > 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: [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). > > > > > > 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 [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] 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: [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.com -- Author: INET: [EMAIL PROTECTED] 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: [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.com -- Author: INET: [EMAIL PROTECTED] 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: [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).