Oracle Current User SQL

Select Sesion.sid,
sesion.serial#,
Sesion.username,
SESION.SQL_ID,
Sesion.sql_child_number,
Optimizer_mode,
Hash_value,
Address
Sql_text
From V$sqlarea Sqlarea, v$session sesion
where Sesion.sql_hash_value = Sqlarea.hash_value
and sesion.sql_address = sqlarea.address
And sesion.username is not null;

Print SQL HTML

Set Linesize 1000
Set Trimspool on
Set term off verify off feedback off pagesize 999
Set markup HTML on ENTMAP in spool on
Set echo off
spool/tmp/html1.html Replace
SELECT * FROM table;
Spool off
Set markup HTML off
Set echo on

-------------------

avast:c63088777h1200a0413-azhfez79

Oracle Current User SQL