find_sql.sql

accept sql_text -
prompt 'Enter sql_text :'
set pagesi 1000
set linesi 190
set verify off
column sql_text format a55
col sql_id format a20
col last_active_time format a30
select  sql_id,plan_hash_value,SQL_PLAN_BASELINE,max(last_active_time) last_active_time,max(sql_text) sql_text from v$sql where lower(sql_text) like lower('%&sql_text%') and sql_text not like '%where sql_text like%' group by sql_id,plan_hash_value,SQL_PLAN_BASELINE order by 4;
undef sql_text;