Alternately on earlier versions where the order by
can't be used, is to select from the table in indexed
order using a hint...
hth
connor
- Regina Harter <rharter_at_emc-inc.com> wrote: > Well,
it won't work in all cases, but I have on
> occasion used as a shortcut:
>
> INSERT INTO ... SELECT DISTINCT transaction_date,
> ...
>
> since the distinct will order it for you, beginning
> with the first item in
> the select.
> A more reliable way would be to use pl/sql, select
> the ordered data into a
> cursor, then insert one by one.
>
> At 02:45 PM 5/25/01 -0800, you wrote:
> >We have un-ordered data in a table that needs to be
> inserted into a
> >transaction table in
> >order of the date that the transaction took place.
> >
> >Oracle does not allow "INSERT ..... AS SELECT .....
> ORDER BY....."
> >or "CREATE TMP_TABLE ..... AS SELECT ..... ORDER
> BY......"
> >
> >Is there a method by which I can accomplish this.
> >
> >Thank you in advance
> >
> >Darren Browett
> >Sys Admin
> >City of Coquitlam
> >--
> >Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> >--
> >Author: Browett, Darren
> > INET: dbrowett_at_city.coquitlam.bc.ca
> >
> >Fat City Network Services -- (858) 538-5051
> FAX: (858) 538-5051
> >San Diego, California -- Public Internet
> access / Mailing Lists
>
>--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an
> E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB
> ORACLE-L
> >(or the name of mailing list you want to be removed
> from). You may
> >also send the HELP command for other information
> (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Regina Harter
> INET: rharter_at_emc-inc.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
"Some days you're the pigeon, some days you're the statue"
Do You Yahoo!?
Get your free @yahoo.co.uk address at
http://mail.yahoo.co.uk
or your free @yahoo.ie address at
http://mail.yahoo.ie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Mon May 28 2001 - 05:05:16 CDT
