RE: Creating a sorted table

] lam.bc.ca cc: Sent by: Fax to: [EMAIL PROTECTED] Subject: Creating a sorted table 05/25/2001 06:45 PM

RE: Creating a sorted table

Title: RE: Creating a sorted table That is version specific, but you can use an index hint to do this in older versions. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Messag

RE: Creating a sorted table

|| Subject: RE: Creating a sorted table || || || This is totally NOT accurate. || || Yes there are performance gains storing index data ordered. || Perhaps great || on range scans. Yes you can reorder tables and indexes. || || Walking on water and developing software from a || specification

OT (everybody has a bad day once in a while...)/ RE: Creating a sorted table

On 30 May 2001, at 8:10, Christopher Spence wrote: This is totally NOT accurate. http://www.amazon.com/exec/obidos/ASIN/B5BYQH ---excerpt--- Tales of the Arabian Nights Barbie and Ken Our Price: $99.99 This item will be

RE: Creating a sorted table

: Sent by: Fax to: root@fatcity.Subject: RE: Creating a sorted table

RE: Creating a sorted table

Title: RE: Creating a sorted table Hi infact creating the table as sorted data from another table works with oracle 8.1.6.3.0 as: create table agrs as select * from agreements order by agr_agreement_number desc; Is this OK?? Vijay -- From: Connor McDonald[SMTP:[EMAIL

Re: Creating a sorted table

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 [EMAIL PROTECTED] wrote: Well, it won't work in all cases, but I have on occasion used as a shortcut: INSERT INTO ... SELECT DISTINCT

Re: Creating a sorted table

: Sent by: Fax to: [EMAIL PROTECTED] Subject: Creating a sorted table

Creating a sorted table

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

Re: Creating a sorted table

to: [EMAIL PROTECTED] Subject: Creating a sorted table

RE: Creating a sorted table

Try insert ... select* from (select * from table_name order by column_name) Alex Hillman -Original Message- Sent: Friday, May 25, 2001 6:45 PM To: Multiple recipients of list ORACLE-L We have un-ordered data in a table that needs to be inserted into a transaction table in order of the

Re: Creating a sorted table

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