Search notes:

Oracle hint: MATERIALIZE

/*+ materialize */ is an undocumented hint.
The hint causes the result of a query in a with clause to be stored in a global temporary table.
Thus, the hint is useful if this result is referred to multiple times in the query. Compare with cache and inline. Apparently, an inline view is materialized when it uses rownum.

See also

The inline and other hints
Materialized views
insert all with sys_guid()

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...', 1740463023, '18.118.7.190', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/SQL/hints/list/materialize(48): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78