userenv('sessionid') : userenv « SQL PLUS Session Environment « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. SQL PLUS Session Environment
3. userenv

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>