Oracle and ISAM - returning records
From: Boogie <boogie_at_boogie-the-cat.demon.co.uk>
Date: Wed, 06 Jan 1999 05:43:22 -0800
Message-ID: <%LJk2.694$h5.12830537_at_WReNphoon1>
Date: Wed, 06 Jan 1999 05:43:22 -0800
Message-ID: <%LJk2.694$h5.12830537_at_WReNphoon1>
Hi Al
If it's only the first x number of rows you are processing, how about the following
select yval
from test_table
where rownum < (x number of rows to fetch)
order by yval
where (x number of rows to fetch) is a numeric value
Alternatively you could use a pre-compiler such as PROC*C and utilise the host array facility
Boogie
- Posted from RemarQ - http://www.remarq.com - Discussions Start Here (tm) ***