sequences and order by

From: david wendelken <davewendelken_at_earthlink.net>
Date: Thu, 6 May 2004 16:34:15 -0700 (PDT)
Message-ID: <5569268.1083886455608.JavaMail.root@daisy.psp.pas.earthlink.net>

I've been coding pl/sql for 16 years or so and just ran into something today that surprised me.

I was doing a standard Insert into ... select ... from ... statement.

I had a sequence_name.nextval in the select clause and an order by clause on the select statement.

Oracle wouldn't accept the use of the NEXTVAL with an ORDER BY.

Has it always been that way?

Have I really coded hundreds of complex programs and just never run into that before?

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Thu May 06 2004 - 18:32:02 CDT