Oracle PL/SQL/SQL Plus/USERENV

userenv("sessionid")

   <source lang="sql">
  

SQL> SQL> -- ALTER SESSION SET SQL_TRACE = TRUE SQL> -- SQL statement(s) to be traced ... SQL> -- ALTER SESSION SET SQL_TRACE = FALSE SQL> SQL> SQL> select a.spid

 2  from v$process a, v$session b
 3  where a.addr = b.paddr
 4  and b.audsid = userenv("sessionid")
 5  /

928 1 row selected. SQL>

 </source>
   
  

USERENV("TERMINAL")

   <source lang="sql">
 

SQL> SQL> SELECT USERENV("TERMINAL") FROM DUAL; USERENV("TERMINA

---

J SQL> SQL>

 </source>