Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Table/view to generate integers from 1 to 500

Re: Table/view to generate integers from 1 to 500

From: Kirtan Acharya <kirtan.acharya_at_gmail.com>
Date: 17 Jan 2005 03:54:38 -0800
Message-ID: <1105962878.334000.216510@f14g2000cwb.googlegroups.com> 





Hi,


I'd like to add that this query will retrieve numbers only till the 9th
power of 2 i.e. 512. So if u need higher numbers, keep on adding digits
to the end of the list


group by cube(1,2,3,4,5,6,7,8,9,10,11,12....)



hope this helps,


kirtan
Received on Mon Jan 17 2005 - 05:54:38 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US