Advertisement
Guest User

Untitled

a guest
Sep 6th, 2019
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select o.*
  2. from sys_object o,
  3.      SYS_AU_ACTION a,
  4.      SYS_AU_ACTION_TYPE ac
  5. where a.ACTION_TYPE_ID = ac.id
  6.   and ac.ident in ('UPDATE_OBJECT', 'CREATE_OBJECT')
  7.   and a.user_id in ('800', '1')
  8.   and a.stamp between '2019-08-01' and '2019-09-01'
  9.   and o.id = a.obj_id
  10. group by o.id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement