| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Monday dumb question...
Just update it
update tab1 set col1=rownum-1;
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Shreeni
Sent: Monday, January 08, 2007 5:46 PM
To: oracle-l_at_freelists.org
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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 08 2007 - 16:55:03 CST
 |
 |