Re: Monday dumb question...
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: shreeni@xxxxxxxxxxxxx
- Date: Mon, 08 Jan 2007 17:36:12 -0700
if you are on 9i or higher this will work:
select rownum-1 from dual connect by level <= 100
At 03:45 PM 1/8/2007, Shreeni wrote:
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
Regards
Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
Other related posts:
