<div>
srinivas_gowd,<br />
<br />
&nbsp; I think it will be helpful to all &nbsp;if u specify where this &nbsp;series is going to be used.Inside a function as a cursor or just inside some reports or anything .I dont think there is a way to generate using sql query the numbers between all ranges .<br />
U might need to write a function for that .or may be u can use dbms_sql to create a sqeunce dynamically and then drop it later on after the use .It all depends on where u r going to use it .<br />
&nbsp; just curious to know where such a provision is needed .<br />

</div>


srinivas_gowd,

  I think it will be helpful to all  if u specify where this  series is going to be used.Inside a function as a cursor or just inside some reports or anything .I dont think there is a way to generate using sql query the numbers between all ranges .
U might need to write a function for that .or may be u can use dbms_sql to create a sqeunce dynamically and then drop it later on after the use .It all depends on where u r going to use it .
  just curious to know where such a provision is needed .


<div>
<div class="content wysiwyg-content">
Can Any body help me,<br />
<br />
Generating a series of continuous numbers in oracle accepting from and two numbers from the user(using sql query)<br />
<br />
hello friends i want to generate a series of numbers in oracle,i will pass from and to numbers,now it has to generate a series of numbers between given from and to numbers.using sql query<br />
<br />
thanks in advance<br />
<br />
srinivas gowd<br />
<br />
srinivas_gowd@yahoo.co.uk
</div>
</div>


Can Any body help me,

Generating a series of continuous numbers in oracle accepting from and two numbers from the user(using sql query)

hello friends i want to generate a series of numbers in oracle,i will pass from and to numbers,now it has to generate a series of numbers between given from and to numbers.using sql query

thanks in advance

srinivas gowd

srinivas_gowd@yahoo.co.uk

Generating a series of continuous numbers in oracle accepting from and two numbers from the user(using sql query)

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.