FilesExpand file tree

 main

/

find_objects_2.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

34 lines (33 loc) · 988 Bytes

 main

/

find_objects_2.sql

Copy path

Top

File metadata and controls

• Code
• Blame

34 lines (33 loc) · 988 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

undef object_string

@plusenv

col oname format a40

col subobj format a30

col objtype format a10 trunc

col sta format a03 trunc

col syn format a44

col created format a15

col lastddl format a15

col objid format 9999999999

col ar format a02 head '=>'

break on syn

select decode(s.synonym_name,null,' ',s.owner||'.'||s.synonym_name) syn

,decode(s.synonym_name,null,' ','=>') ar

,o.owner||'.'||o.object_name oname

,subobject_name subobj

,object_type objtype

,status sta

,object_id objid

,to_char(created,'YYMMDD HH24:MI:SS') created

,to_char(last_ddl_time,'YYMMDD HH24:MI:SS') lastddl

from dba_objects o

,dba_synonyms s

where (o.object_name like upper('%&&object_string%')

or s.synonym_name like upper('%&&object_string%'))

and o.owner = s.table_owner (+)

and o.object_name = s.table_name (+)

and object_type not like '%PARTITION%'

and object_type not in ('SYNONYM')

order by o.owner||'.'||o.object_name

,s.owner||'.'||s.synonym_name

,object_type

;