Re: sequences

From: Tim Boemker <tim_boemker_at_zacatecas.optimum.com>
Date: 1995/07/28
Message-ID: <3vaoik$r6m_at_jalisco.optimum.net>#1/1


In article <1995Jul28.112337.22967_at_ucl.ac.uk> ucfaabe_at_ucl.ac.uk (Mr Angus Beare) writes:

> I can send a request to the database like 'select SEQ.nextval from samples'
> but this returns a number for every row in the table.

Use "select SEQ.nextval from dual".
[Oracle7 Server Application Developer's Guide, p. 2-17]

Tim Boemker
Optimum Group
(513) 577-7785 Received on Fri Jul 28 1995 - 00:00:00 CEST

Original text of this message