I want to retrieve all the rows from table with out using cursor or PL/SQL table of records -- Vinod Kumar Pothuri (kumar_vinod@hotmail.com), March 30, 2004