Leafing through this list and studying Perl and DBI on books I'm now
able to connect to my Oracle NT server from my linux laptop through
perl and DBI scripts.
But I have troubles to indicate in an sql query that a value must be
null. I'm using the following code:
my $sql = $dbh->prepare("SELECT cat_term, sum(ptz_eff_netta), sum(ptz_eff_lorda)
FROM PN.GT_ATTR GROUP BY tipo_valore, cat_term
HAVING (tipo_valore='R' and data_inizio IS NULL) ORDER BY cat_term");
$sql->execute();
This sql works fine with DB2 but Oracle doesn't like it. What's wrong with it?
Ciao
Vittorio
