HELP: How to rewrite sorted records back to a table?
Date: 1996/09/20
Message-ID: <32430AE0.199_at_baymont.com>#1/1
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
Received on Fri Sep 20 1996 - 00:00:00 CEST