current sql

[Jhood]

What syntax can I use to get the current sql for use with a trigger. the sys_contex('USE RENV','CURRENT_ SQL') does not seem to return the sql.

[goudelly]

hI,

sys_context('US ERENV','CURRENT _SQL') FROM DUAL;

It will execute the query

Thanks,

Mohan Reddy G