Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Query Select

 

SELECTs using the ORDER BY clause with rownum

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