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

Re: how to select a sequence value?

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: Wed, 08 Jul 1998 18:45:12 GMT
Message-ID: <6o0enh$24d@bgtnsc03.worldnet.att.net>


On Wed, 8 Jul 1998 16:58:54 +0200, "Marc Iven" <marc.iven_at_dastronic.be> wrote:

> SELECT order_seq.NEXTVAL FROM dual;
>
>This allways returns an empty result. Can anyone give
>me some help?

Hmmm... It should return a number. Try doing this:

        SELECT * FROM dual;

You should see one column in the result, which I believe is named DUMMY, and it should have one row, which I believe contains an 'X'. If you don't see that, you should log on as user SYS and insert one record into your DUAL table.

regards,

Jonathan Received on Wed Jul 08 1998 - 13:45:12 CDT

Original text of this message

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