Re: Perl and NT and SQLPLUS

Paul Rech wrote:
>
> 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

You could achieve the same thing (I think - I'm not a PERL user) with awk. As a last resort, you could buy MKS toolkit for NT which will give you Unix utilities like ksh, awk, grep, etc. This is the major advantage that Unix has over the PC operating systems. Or you could always migrate to Solaris??

-- 
---
Allen Kirby			AT&T ITS Production Services
akirby_at_att.com			Alpharetta, GA.