Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Query Select

 

Order by username

SQL> SQL> SELECT username, default_tablespace   2  FROM dba_users   3  where rownum < 50   4  ORDER BY username desc; USERNAME                       DEFAULT_TABLESPACE ------------------------------ ------------------------------ XDB                            SYSAUX TSMSYS                         SYSTEM SYSTEM                         SYSTEM SYS                            SYSTEM PLSQL                          USERS OUTLN                          SYSTEM MDSYS                          SYSTEM RNTSOFT                         SYSTEM HR                             USERS FLOWS_FILES                    SYSAUX FLOWS_020100                   SYSAUX DIP                            SYSTEM DBSNMP                         SYSAUX CTXSYS                         SYSAUX ANONYMOUS                      SYSAUX 15 rows selected.