Home -> Usenet -> comp.databases.oracle -> Re: Problem with Oracle queries

Re: Problem with Oracle queries

From: Robert Boyle <rboyle_at_cyantel.com>
Date: 27 Sep 2001 06:43:49 -0700
Message-ID: <8729a6fe.0109270543.1b6f0916_at_posting.google.com> 







Are you trying to return the sequence with the SELECT statement?  Why?



If you have a trigger (do you, because it doesn't seem like you do)
the trigger would do a SELECT sequence.NEXTVAL INTO unique_fieldname
FROM DUAL; and you do not then need to explicitly write this
statement.
Received on Thu Sep 27 2001 - 15:43:49 CEST












Original text of this message