From ssharma1@fcsltd.com Fri, 20 Jul 2001 06:01:34 -0700 From: "Saurabh Sharma" Date: Fri, 20 Jul 2001 06:01:34 -0700 Subject: urgent pls...PL/SQL problem.. Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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   saurabh00pc@yahoo.comhttp://www.geocities.com/saurabh00pc/stride.html