Re: how to detect records order in a table with no id, timestamp?

From: TurkBear <jvgreco_at_pop.primenet.com>
Date: 1997/11/04
Message-ID: <345f670e.78812426_at_news.primenet.com>#1/1


[Quoted] Unless I misunderstand you question, you can do:  select col_name1,col_name2,col_name3 from table_name ORDER BY col_name3 ( for instance )

John Greco
Oracle DBA
Reply to john.greco_at_dot.state.mn.us

lesliet_at_u.washington.edu (L. Tseng) wrote:

>Is it possible to order an oracle table output when table does not have
>any id and timestamp info?
>
>In MS SQL Server and Sybase, it seems the record just got inserted or updated
>always comes out the last in select.
>
>Thanks for the help in advance,
>
>Leslie
>--
>=-=-=-=-=-=-=-=-=-=-=
>Leslie Tseng
>lesliet_at_writeme.com
>=-=-=-=-=-=-=-=-=-=-=
Received on Tue Nov 04 1997 - 00:00:00 CET

Original text of this message