Hi dba ,

I want to create a script which performs audit on all users who do select statement with string " subno='xxxxxxxx' " , I want to get those 8 chars (shown as x) that arrives just after clause "where"

select timestamp,db_user,os_user,sql_text from dba_fga_audit_trail

for example sql_text=

select b_subno NUMERO , to_char(transdate,'DD/MM/YYYY HH24:MI:SS') DATE_APPEL ,
lpad(to_char(floor(act_duration/60)),3)||':'||lpad(to_char(mod(act_duration,60)),2,'0') DUREE ,tariff_group GENRE_APPEL, decode(call_type,'001','App.Emis','002','App.Reçu','030','SMS Reçu','031','SMS Emis',call_type) Sens , IMEI_NUMBER Phone_set from calls.PP_DETAILS where subno ='74593434'AND transdate between '25-09-2006' and '26-09-2006' order by transdate desc

I want to get 74593434 from "... where subno ='74593434'AND.."
I don't know use ctxsys function or other manipulation text functions!

Thanks in advance

Oracle LazyDBA home page