RE: Pl/SQL Question

From: David Wendelken <davewendelken_at_earthlink.net>
Date: Tue, 23 Aug 2005 11:04:12 -0400
Message-ID: <00a801c5a7f3$ec3cdb70$6401a8c0@davidwendelken>

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

Yes, you can select directly from a sequence.

But, they needed a routine that would enable them to specify the sequence name at run-time, not at programming time. That's why the function is being used.

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

Received on Tue Aug 23 2005 - 10:02:44 CDT