Sorting by primary key

From: Gordon Duns <Gordon_at_gctd.demon.co.uk>
Date: 1995/09/13
Message-ID: <754551476wnr_at_gctd.demon.co.uk>#1/1


Is there a way of selecting records from a table in order of primary key without specifying the column names? What I want to do is generate a series of SQL enquiries as follows :-

select 'select * from scott.' || table_name || ' order by ??????;'

       from dba_tables
       where owner='SCOTT';

?????? being the primary key of each table.

-- 
GD
Received on Wed Sep 13 1995 - 00:00:00 CEST

Original text of this message