View HLPDTEST.STATEGPS.IDEPTREE 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
DEPENDENCIES varchar2 4000  √  null

Analyzed at Thu Aug 11 01:05 IST 2022

View Definition:
select lpad(' ',3*(max(nested_level))) || max(nvl(type, '<no permission>') || ' ' || schema || decode(type, NULL, '', '.') || name) from deptree group by seq# /* So user can omit sort-by when selecting from ideptree */
 
Possibly Referenced Tables/Views: