ERPstuff - Oracle EBS Community

Hi All,
can we sort the data on the basis of some column while default displaying in table?
e.g if we write the query (select * from emp)
then record set displayed will be sort on some column by default
although we havn't write any order by clause in the query.
can we define such things at table definition level?
How to do it?

I tried my best to explain the question, i don't know it is clear or not [:)]

Regards,
Adnan

I have updated the subject of your topic please next time provide meaninful subject instead of just saying Help!!!!. Thanks

by definition, a relational database doesn't store records in any type of order. If you needed this, you'll need to look into using a view, personalizations or maybe create an index-organized table, which I believe you can sort by.