Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Perl and NT and SQLPLUS
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
![]() |
![]() |