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 ...