Search notes:

SQLPATH - who-am-i.sql

who-am-i.sql originally reported just the user that run this SQL script. Over time, the number of selected column increased and now also show database name, server name etc. so that the script probably should be named more accurately who-am-I-and-where-am-I-anyway.sql.

select
   substr   (user                                    , 1, 30) usr,
   substr   (sys_context('userenv', 'current_schema'), 1, 30) current_schema,
   to_number(sys_context('userenv', 'sid'           )       ) sid,
   substr   (sys_context('userenv', 'session_user'  ), 1, 30) session_user,
   substr   (sys_context('userenv', 'db_name'       ), 1, 30) db_name,
   substr   (            ora_database_name           , 1, 30) ora_database_name,
   substrb  (            global_name                 , 1, 30) global_name,
   substr   (sys_context('userenv', 'server_host'   ), 1, 30) server_host,
   substr   (sys_context('userenv', 'service_name'  ), 1, 30) service_name
from
   global_name;

Github repository Oracle-SQLPATH, path: /who-am-i.sql

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...', 1741097852, '3.149.249.107', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/SQL-Plus/sqlpath/who-am-i(55): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78

SQLPATH - who-am-i.sql

See also