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

From: jeff davidson <davidson_at_ix.netcom.com>
Date: 1996/09/22
Message-ID: <3245D63D.2F3_at_ix.netcom.com>#1/1


  1. Jorge Florindo wrote:
    >
    > 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
    >
    rename your table and create a view that reads something like: create view emp as select * from emp_old order by deptno.
Received on Sun Sep 22 1996 - 00:00:00 CEST

Original text of this message