View HLPDTEST.STATEGPS.LEAVECONFIRMATIONVIEW 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
ORDER_NUM number 22  √  null
LEAVECONFIRMATION char 8  √  null

Analyzed at Fri Aug 14 01:05 IST 2020

View Definition:
select 1 as order_num,'Definite' as Leaveconfirmation from dual union select 2,'Probable' from dual