|
hi list,
i'm conerting my old db structure
into a new one with entirely different constraints, references,
etc..
the new structure holds many new
tables some splitted from old ones with few new columns. and like.
now i want to move my old data into
this new one.
i 'm doing it through pl/sql, writing
procedures, etc.
now my problem is i've a master table
for skills. and a detailed table referencing it. previously the detailed table
stores the values with no ref. to the master, now it is storing the code
corresponding the master value. i want to compare the old detailed table and old
master table's values to fetch the code from the master table.
when i try to fetch this through
cursor, the values containing null in detailed table are returning error..
while rest going fine.
how do i treat the nulls, the
nvl(col,'0') to convert nulls to 0 is also not working.
any idea.
Saurabh Sharma
|
