View HLPDTEST.STATEGPS.HALFDAYVACATION 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
HALFDAY varchar2 50  √  null

Analyzed at Mon May 23 01:05 IST 2022

View Definition:
select 1 as order_num, 'First Half In From Date' as halfday from dual union select 2, 'Second Half In From Date' from dual union select 3, 'First Half In To Date' from dual union select 4, 'Second Half In From Date And First Half In To Date' from dual order by 1