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

Home -> Community -> Usenet -> c.d.o.misc -> Perl and NT and SQLPLUS

Perl and NT and SQLPLUS

From: Paul Rech <paul.rech_at_medtronic.com>
Date: 1997/01/02
Message-ID: <32CC0674.B6F@medtronic.com>#1/1

With Perl on any UNIX platform you can do something like this:

#!/usr/local/bin/perl

@crud = `sqlplus -s << EOF

         blorch/blorch_word

         select * from felch;

         exit
         EOF`;


then you can loop through the results mixing and matching, etc.

foreach $barf (@crud) {

   do something
}

How do you do something like this on an NT platform seeing as the here document in my example is specific to UNIX?

Paul Rech
Oracle DBA Received on Thu Jan 02 1997 - 00:00:00 CST

Original text of this message

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