View HLPDTEST.STATEGPS.DEPTREE Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
NESTED_LEVEL number 22  √  null
TYPE varchar2 19  √  null
SCHEMA varchar2 30  √  null
NAME varchar2 30  √  null
SEQ# number 22  √  null

Analyzed at Thu Aug 11 01:05 IST 2022

View Definition:
select d.nest_level, o.object_type, o.owner, o.object_name, d.seq# from deptree_temptab d, all_objects o where d.object_id = o.object_id (+)
 
Possibly Referenced Tables/Views: