Listing And Searching Table Examples

If you want to search by a known pattern the exact name of a table:

SQL> select TABLE_NAME from user_tables where TABLE_NAME like '%FICHERO%' ;



ORDER BY Example:

SQL> select * from employee ORDER BY JOB_GRADE,EMP_NO;
    EMP_NO JOB_GRADE            EMP_NAME             EMP_SNAME
---------- -------------------- -------------------- --------------------
         1 BOFH                 David                Aniones
         5 BOFH                 Peter                Perkins
         2 BOSS                 Ramon                Monina
         4 GOD                  Xesar                Palerta
         3 MANAGER              Onin                 Onionhood