Guest User

Untitled

a guest
Jul 18th, 2018
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.27 KB | None | 0 0
  1. select distinct
  2. t.sql_id,
  3. s.SQL_TEXT
  4. from v$session t
  5. inner join v$sql s
  6. on t.sql_id = s.sql_id
  7. where t.status = 'ACTIVE'
  8. and ( upper(s.SQL_TEXT) like '%INSERT%TEST_DATA%'
  9. or upper(s.SQL_TEXT) like '%UPDATE%TEST_DATA%')
Add Comment
Please, Sign In to add comment