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

John,

[Quoted] Sorry for the confusion. Let me give an example:

insert into testtable values (2,b);
insert into testtable values (3,c);
insert into testtable values (1,a);

then, select * from testtable would look like this

  2      b
  1      a
  3      c

or
  3      c
  1      a
  2      b

or
  1      a  
  2      b
  3      c

or the way they were inserted
  2      b
  3      c
  1      a

Without any other information availble, how can you tell the order of the insertion from select output?  

In article <345f670e.78812426_at_news.primenet.com>, TurkBear <jvgreco_at_jnospamprimenet.com> wrote:
>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
>>=-=-=-=-=-=-=-=-=-=-=
>

-- 
=-=-=-=-=-=-=-=-=-=-=
Leslie Tseng
lesliet_at_writeme.com
=-=-=-=-=-=-=-=-=-=-=