Dear dbi-users,
I know this is not strictly dbi, however it is a problem when trying to
insert 0's into an Oracle database. My problem is that I have a column in a
table that can contain NULL, 0, or 1. I want to read from this table and
insert the data into another table, or update the data if it has changed so
it is the same as the source table.
source Destination
ID Column1 ID Column1
1 NULL 1 0
2 0 2 0
3 1 3 1
etc.
Here I need to update Destination.Column1 to be NULL.
The best I could come up with is:
if ((length($i) == 0 && length($j) == 0) ||
(($i == $j) && length($i) == length($j))) {
return 1;
}else{
return 0;
}
where:
$i - value from source table
$j - value in destination table
Somehow, this does not leave me feeling all warm and fuzzy inside. Anyone
have a better suggestion?
Cheers,
Michael
([EMAIL PROTECTED])
