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 -> how to select a sequence value?

how to select a sequence value?

From: Marc Iven <marc.iven_at_dastronic.be>
Date: Wed, 8 Jul 1998 16:58:54 +0200
Message-ID: <6o00le$4ef$1@news3.Belgium.EU.net>


Hi,

I've create some sequence values and can use them in insert statements. The manual says it can also be used in a query like

    SELECT order_seq.NEXTVAL FROM dual;

This allways returns an empty result. Can anyone give me some help?

Thanks,
Marc. Received on Wed Jul 08 1998 - 09:58:54 CDT

Original text of this message

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