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

    user9377303

      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

       

      Ciao

      Andrea