Search notes:

Oracle SQL: SELECT - ORDER BY clause

It's not possible to order a result set on a long data type. Trying to do so causes the error message ORA-00997: illegal use of LONG datatype.
The behavior of order by is influenced by the value of nls_sort (even if nls_comp is set to binary, see MOS Note 227335.1).
An order by clause might contain aggregate functions.

See also

Oracle recommends to use deterministic user defined PL/SQL functions if they're used in order by clauses.
The SQL work area in the PGA.
ORA-01791: not a SELECTed expression
Using order by in a view prevents the view from being updatable.

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1758191939, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/SQL/select/order-by/index(51): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78