]
cc:
Subject:Re: Selecting Next X Values From Dual
Stephane...
Thanks for the reply.
SELECT sequence.nextval FROM table WHERE ROWNUM x
It just seems too kludgy, and I didn't think creating a table with
dummy data for the count would be a good way to go. Any suggestions
If X is fixed for all sessions, do a step increase of X so that you only have
to select 1 row from dual.
Anjo.
On Friday 27 September 2002 00:18, you wrote:
All...
Is there a method by which I can select the next x values from a
sequence from dual? I've searched Google and OraFAQs.com,
Anjo...
Thanks for the reply!!
If X is fixed for all sessions, do a step increase of X so that you
only have to select 1 row from dual.
Unfortunately, I don't feel I can do that. I'm using the returned
values as unique identifiers to protect against duplicate database
submissions from a
I created a package that would easily loop thru and select x number of
entries, but not return them in a select to you. This way, you can make 1
simple call passing it X.
Is that what you wanted ??? Or do you have to have them as returned values
of a select ?
Kevin
-Original
I created a package that would easily loop thru and select x number of
entries, but not return them in a select to you. This way, you can
make 1 simple call passing it X. Is that what you wanted ??? Or do you
have to have them as returned values of a select ?
I would need the values
Gary Chambers wrote:
I created a package that would easily loop thru and select x number of
entries, but not return them in a select to you. This way, you can
make 1 simple call passing it X. Is that what you wanted ??? Or do you
have to have them as returned values of a select ?
I
Stephane...
Thanks for the reply.
SELECT sequence.nextval FROM table WHERE ROWNUM x
It just seems too kludgy, and I didn't think creating a table with
dummy data for the count would be a good way to go. Any suggestions?
Why 'too kludgy' ? If you are inside a PL/SQL package have you
All...
Is there a method by which I can select the next x values from a
sequence from dual? I've searched Google and OraFAQs.com, but I can't
seem to make any hits on my search request. TIA
Gary Chambers
//-
// Lucent Technologies GIO/Unix
// 4 Robbins
Gary Chambers wrote:
All...
Is there a method by which I can select the next x values from a
sequence from dual? I've searched Google and OraFAQs.com, but I can't
seem to make any hits on my search request. TIA
Gary Chambers
//-
// Lucent