RE: sequences and order by
- From: "Mohan, Ross" <RMohan@xxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 6 May 2004 19:38:26 -0400
something to do w/transactional status not being bipolar...
lol...sorry, it's late I am fried....
-----Original Message-----
From: david wendelken [mailto:davewendelken@xxxxxxxxxxxxx]
Sent: Thursday, May 06, 2004 7:34 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: sequences and order by
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@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
