ingore the "use ORA;" in my example
Erick Nelson wrote:
> you can if you prepare and use fetchrow_hashref and rows...
>
> use DBI;
> use ORA;
>
> my $dbh = DBI->connect(...connect stuff here...)) || die $DBI::errstr;
> my $sql = "select * from sfile";
> my $sth = $dbh->prepare($sql) || die $dbh-
you can if you prepare and use fetchrow_hashref and rows...
use DBI;
use ORA;
my $dbh = DBI->connect(...connect stuff here...)) || die $DBI::errstr;
my $sql = "select * from sfile";
my $sth = $dbh->prepare($sql) || die $dbh->errstr;
$sth->execute || die $sth->errstr;
while (my $href = $sth->fet
Hello,
I am executing a query that in some cases dont have an entry for the
instrument_id I am using to retrieve by. I.e there is no physically record
in there (NVL wouldnt work).
This is a peice of code i am struggking with:
undef $ticker;
$sql="SELECT SUBSTR(ISS_ID,1, INSTR(ISS_ID,' ',1
