Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How get the current value from a sequence?

Re: How get the current value from a sequence?

From: Ubiquitous <weberm_at_polaris.net>
Date: Tue, 30 Nov 2004 06:10:59 -0500
Message-ID: <cohkou$son$1@news.utelfla.com>


In article <%RLqd.25958$up1.3264_at_text.news.blueyonder.co.uk>, x_at_x.com says...

>need to be dba to read that view

Does running a stored procedure change one's role?

>whats wrong with select seq_name.nextval fom dual?

I don't want to gaps in the sequence. Received on Tue Nov 30 2004 - 05:10:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US