ТЕМА:

SQL> select  *
  2    from  v$version
  3  /

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod
PL/SQL Release 10.2.0.4.0 - Production
CORE    10.2.0.4.0      Production
TNS for 32-bit Windows: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

SQL> create table t(txt varchar2(10))
  2  /

Table created.

SQL> create or replace
  2    trigger trg
  3      before insert
  4      on t
  5      declare
  6          sql_text varchar2(1000);
  7      begin
  8          select  sql_text
  9            into  sql_text 
 10            from  v$sql s,
 11                  v$session e
 12            where s.sql_id = e.sql_id
 13              and e.sid = sys_context('USERENV','SID');
 14          dbms_output.put_line(sql_text);
 15  end;
 16  /

Trigger created.

SQL> set serveroutput on
SQL> insert into t values ('michel');
insert into t values ('michel')

1 row created.

SQL> select  *
  2    from  v$version
  3  /

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE    11.2.0.2.0      Production
TNS for HPUX: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production

SQL> create table t(txt varchar2(10))
  2  /

Table created.

SQL> create or replace
  2    trigger trg
  3      before insert
  4      on t
  5      declare
  6          sql_text varchar2(1000);
  7      begin
  8          select  sql_text
  9            into  sql_text 
 10            from  v$sql s,
 11                  v$session e
 12            where s.sql_id = e.sql_id
 13              and e.sid = sys_context('USERENV','SID');
 14          dbms_output.put_line(sql_text);
 15  end;
 16  /

Trigger created.

SQL> set serveroutput on
SQL> insert into t values ('michel');
SELECT SQL_TEXT FROM V$SQL S, V$SESSION E WHERE S.SQL_ID = E.SQL_ID AND E.SID = SYS_CONTEXT('USERENV','SID')

1 row created.

SQL>

SQL> insert into t values ('michel');
SQL> create or replace
  2    trigger trg
  3      before insert
  4      on t
  5      declare
  6          sql_text varchar2(1000);
  7      begin
  8          for v_rec in (
  9                        select  sql_text
 10                          from  v$open_cursor
 11                       ) loop
 12            dbms_output.put_line(sql_text);
 13          end loop;
 14  end;
 15  /
SQL> set serveroutput on
SQL> insert into t values ('michel');
SQL>