Re: Pl/SQL Question

Depends if you take the OP's questions literally. If you want to use a proc to find out the sequence's nextval then you need to do it that way.

You could just select in form dual normally without doing a proc - all depends on what the OP actually wants

On 8/23/05, Ram K <lambu999_at_gmail.com> wrote:

> Cant we select directly from a sequence without having to use a
> function? Is there any advantage to using a function?

--
http://www.freelists.org/webpage/oracle-l