Re: re-ordering rows

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Thu, 22 Apr 1999 20:01:22 +0200
Message-ID: <7fno54$61a$1@weber.a2000.nl>

Gennady
> I need to re-order rows in my table

Rows are not stored in any particular order in Oracle databases. You may always get the same order when you perform a query, but Oracle does not guarantee you any order at all. If you rely on it, you'll sure get into problems soon.

If you need a specific order, you simply need to add a "order by" part in your query. For example:

    select table_name, owner
    from all_tables
    order by table_name descending;

Arjan. Received on Thu Apr 22 1999 - 13:01:22 CDT