RE: Monday dumb question...
- From: "Shreeni" <shreeni@xxxxxxxxxxxxx>
- To: "'Venkat Krish'" <venkat.lear@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 8 Jan 2007 17:11:51 -0600
Thanks Venkat....this is just what the doctor ordered .....whooohooo
Thanks and have a good day.
Shreeni
(630) 401-2887 (Mobile)
(630) 837-1730 (Home)
_____
From: Venkat Krish [mailto:venkat.lear@xxxxxxxxx]
Sent: Monday, January 08, 2007 4:53 PM
To: shreeni@xxxxxxxxxxxxx
Subject: Re: Monday dumb question...
insert into <<your table>> select level from dual connect by level<100;
or (
insert into <<your table>>
select rownum from
(select object_name from all_objects where rownum<=10) a,
(select object_name from all_objects where rownum<=10) b
where rownum<100
On 1/8/07, Shreeni <shreeni@xxxxxxxxxxxxx> 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
Other related posts:
