prompt ...wwv_flow_data



create table wwv_flow_data (
    flow_instance        number not null
                         constraint wwv_flow_data_fk
                         references wwv_flow_sessions$
                         on delete cascade,
    item_id              number,
    item_element_id      number,
    item_filter          varchar2(1)
                         constraint valid_item_filter
                         check (item_filter in ('Y','N')),
    session_state_status varchar2(1)
                         constraint valid_session_state_status
                         check (session_state_status in ('I','U','R')),
    flow_id              number,
    item_name            varchar2(255),
    name_length          int,
    item_value           clob)
    storage (initial 1M next 1M freelists 20)
    lob (item_value) store as (cache reads enable storage in row)
/




create unique index WWV_FLOW_DATA_IDX1 on wwv_flow_data (FLOW_INSTANCE,ITEM_ID);
create index WWV_FLOW_DATA_IDX2 on wwv_flow_data (flow_id,FLOW_INSTANCE);

prompt ...wwv_flow_data
--==============================================================================
-- session state
--
-- IF YOU CHANGE THIS TABLE OR IT'S INDEXES
-- do not forget to synchronize ../utilities/apxpart.sql
--==============================================================================
create table wwv_flow_data (
    flow_instance        number
                         constraint wwv_flow_data_session_fk
                         references wwv_flow_sessions$
                         on delete cascade,
    item_id              number,
    item_filter          varchar2(1)
                         constraint valid_item_filter
                         check (item_filter in ('Y','N')),
    session_state_status varchar2(1)
                         constraint valid_session_state_status
                         check (session_state_status in ('I','U','R')),
    flow_id              number,
    item_name            varchar2(255),
    is_encrypted         varchar2(1),
    item_value_vc2       varchar2(4000),
    item_value_clob      clob,
    constraint wwv_flow_data_pk primary key (flow_instance, item_id)
                         using index (
                             create index wwv_flow_data_pk on wwv_flow_data (flow_instance,item_id)
                             compress 1) )
    storage (initial 1M next 1M freelists 20)
    initrans 8 maxtrans 255
    lob (item_value_clob) store as (cache reads disable storage in row)
/

create index WWV_FLOW_DATA_IDX1 on wwv_flow_data (flow_id) compress 1
/

-- для версии 5.0
select count(case when t.item_value_clob is not null then 1 end) 
       / (count(case when t.item_value_clob is not null then 1 end) + count(t.item_value_vc2)) clob_proportion
     
     , count( distinct
             ( select t2.flow_id
               from apex_050000.wwv_flow_step_items t2
                  , APEX_050000.wwv_flows t3
               where t2.id = t.item_id
                 and t2.flow_id = t3.id
                 and t3.security_group_id not in (10,11,12) )) distinct_apps
from apex_050000.wwv_flow_data t