perlquestion
myuserid7
Hi <br>
I have a 'select query' to an oracle database.
<code>
my ($sql, $dbh) = @_;
my $sth=$dbh->prepare($sql);
$sth->execute() or die "ERROR : execute error ",$sth->errstr(), "\n" ;
my $returnArrayRef = $sth->fetchall_arrayref
</code>
Now, I like to convert the code to shell script using sqlplus. How should I wrap around the $sql using sqlplus to achieve the same thing from a shell script? <p>
Thanks.