Re: How to so select on sequence ?
From: Manoj Das <mdas_at_digitus.co.uk>
Date: 1996/09/19
Message-ID: <32418614.1E97_at_digitus.co.uk>#1/1
Date: 1996/09/19
Message-ID: <32418614.1E97_at_digitus.co.uk>#1/1
Shinu Gupta wrote:
>
The syntax in general -
SELECT My_Sequence_Name.nextval
FROM dual;
In PL/SQL -
DECLARE My_Var NUMBER;
BEGIN
...
SELECT My_Sequence_Name.nextval
INTO My_Var
FROM dual;
...
END;
Hope this helps!
Manoj :-) Received on Thu Sep 19 1996 - 00:00:00 CEST