14 Nisan 2014 Pazartesi

ORACLE USER AUDIT TRAIL DB LOG

SELECT
  FROM user_audit_trail lo
 WHERE
  --LO.OBJ_NAME NOT IN ( 'GOP_SEF_LOK_MV', 'BUTCE_AKTARIMI_TMP','EVENT_TABLE_BRD') AND
  --LO.OBJ_NAME =  'LOKASYON' AND
   trunc(timestamp) > trunc(sysdate)- :KAC_GUNLUK_LOG
order by timestamp desc