×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: SQL
Posted by: Jon Nickerson
Added: Jan 9, 2018 3:52 PM
Views: 3
Tags: no tags
  1. SELECT *
  2. FROM dba_objects
  3. WHERE 1= 1
  4.   AND owner IN ('UTL_D_BIO', 'UTL_D_RES')
  5.   AND OBJECT_NAME LIKE 'RT%'
  6. ORDER BY owner, object_name;