2.14. Pohled "STD_PRJ_PHASE_VW"
| název sloupce | Typ | výchozí | upravitelný |
|---|
| ID | NUMBER ( 22 ) | | Ano |
| KDO | VARCHAR2 ( 120 ) | | Ano |
| KDY | DATE ( ) | | Ano |
| KDY_DMR | VARCHAR2 ( 10 ) | | Ne |
| KDY_DMRHM | VARCHAR2 ( 16 ) | | Ne |
| VISIBLE | VARCHAR2 ( 20 ) | | Ano |
| IS_I | CHAR ( 1 ) | | Ne |
| IS_P | CHAR ( 1 ) | | Ne |
| IS_S | CHAR ( 1 ) | | Ne |
| IS_Z | CHAR ( 1 ) | | Ne |
| ZNAK | CHAR ( 4 ) | | Ano |
| KOD | VARCHAR2 ( 20 ) | | Ano |
| NAZEV | VARCHAR2 ( 800 ) | | Ano |
| NAZEV_CZ | VARCHAR2 ( 800 ) | | Ano |
select
P.ID,
--
P.Kdo,
P.Kdy,
To_Char(P.Kdy,'dd.mm.yyyy') Kdy_DMR,
To_Char(P.Kdy,'dd.mm.yyyy hh24:mi') Kdy_DMRHM,
--
P.Visible,
case when P.Visible like '%I%' then 'Y' else 'N' end is_I,
case when P.Visible like '%P%' then 'Y' else 'N' end is_P,
case when P.Visible like '%S%' then 'Y' else 'N' end is_S,
case when P.Visible like '%Z%' then 'Y' else 'N' end is_Z,
--
P.Znak,
P.Kod,
P.Nazev,
P.Nazev_CZ
from
STD_PRJ_Phase P
