RE: Monday dumb question...

  • From: "Ken Naim" <kennaim@xxxxxxxxx>
  • To: <shreeni@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 8 Jan 2007 17:55:03 -0500

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

Other related posts: