Re: Help with order by and views/tables

From: JHY <jhy_at_earthling.net>
Date: Mon, 29 Jun 1998 20:39:54 -0400
Message-ID: <6n9c4i$dpg@bgtnsc01.worldnet.att.net>

You do not create "ordered tables" in a relational database.

Dietrich Mueller wrote:

> Hi oracle gurus,
> how can I create an ordered table from one which is not ordered
> regarding a certain column?
> Create table ... Insert into ... with order by ... does not work!!! Is
> there a workaround ?
> I do not want to use PL/SQL only plain SQL.
> Any help appreciated!!!
> Thanks a lot in advance
>
> Dietrich
Received on Mon Jun 29 1998 - 19:39:54 CDT