Re: HELP: How to rewrite sorted records back to a table?

Bill Smith wrote:
>
> Hello All,
> What I am trying to do is to sort an Oracle
> table and then write the records back to that table
> in the sorted order. I know that this does not
> make much sense, but what I have is an existing
> program (no source code) that just does a select
> with no order by clause. To make the selected
> records display in order I would like to sort the
> table and write it back. Since you cannot use the
> order by clause when doing a create table or create
> view this may be impossible to do using SQL. If
> anyone has any ideas please email me at
> smithb_at_baymont.com as I cannot keep up this these
> postings. I know that I could dump the table in
> the sorted order and then reload it using
> SQLLOADER but I would rather use SQL if possible.
>
> Thanks in advance,
> Bill Smith

Hi Bill,

Perhaps there are a way, but I need to know more info about your table (Layout, Referencial Integrity, Indexs, etc.)

Regards
Jorge

+----------------------------------+
| A. Jorge Florindo                |
| ajf.63_at_mail.telepac.pt           |
| Portugal                         |
+----------------------------------+