How to display list of tables in order
When i issue SELECT * FROM TAB command in SQL/Plus or anyother tools the list of table is not shown in alphabatic order, instead Oracle shows list in the order in which tables created.
The problem is only with ORACLE 10g Release 2