Just update it update tab1 set col1=rownum-1; _____ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Shreeni Sent: Monday, January 08, 2007 5:46 PM To: oracle-l@xxxxxxxxxxxxx Subject: Monday dumb question... What is the easiest way to populate a column with 0-99 without using a temp table but just plain SQL ?? :-( Thanks and have a good day. Shreeni