3 Replies Latest reply on Oct 3, 2016 11:34 AM by Renato Pedroso

    sql select to extract all the delete statement without where condition from v$sql


      Hi All,


      I have to extract all the delete performed within a certain range time period but only the ones without where condition .


      select * from v$sql where sqltext like 'DELETE%'

      "but" not like 'DELETE% WHERE%';


      I don't if I have well explained my question ........


      thanks anyway