posted 20 years ago
Thats a bit difficult.
As u said,there is no order by on this view that u can use.
The other option is to go into the data dictionary definition for v$session
and figure out the colnames included in the defition of the view itself.
For normal database tables though, you can go to dba_tab_columns and order by on column_name or column_id
for instance
<code>
select column_name, column_id from dba_tab_columns where table_name = 'ACCESS$'
COLUMN_NAME COLUMN_ID
------------------------------ ----------
D_OBJ# 1
ORDER# 2
COLUMNS 3
TYPES 4
</code>
this should give u an idea!
All the best.
Best Regards,<br />Nagendra Prasad.