[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select dvl.name,
dvl.is_owner_dim,
dvl.pers_cwm_name,
dvl.shar_cwm_name,
dvl.aw_name,
dvl.dimension_id,
(select count(*) from zpb_hierarchies where dimension_id = dvl.dimension_id and hier_type<>'NULL') hier_cnt,
dvl.epb_id
from zpb_dimensions_vl dvl
where bus_area_id = p_bus_area_id and
is_data_dim='YES'
order by is_owner_dim desc,
name;
select name,
hier_type,
epb_id,
tab1.table_name pers_table_name,
tab2.table_name shar_table_name,
hierarchy_id
from zpb_hierarchies_vl hier,
zpb_tables tab1,
zpb_tables tab2
where hier.dimension_id = l_dim_id and
hier.pers_table_id = tab1.table_id and
hier.shar_table_id = tab2.table_id;
select levs.name,
levs.epb_id,
levs.pers_cwm_name,
levs.shar_cwm_name
from zpb_levels_vl levs,
zpb_hier_level hrlv
where hrlv.level_id = levs.level_id and
hrlv.hier_id = l_hier_id
order by hrlv.level_order;
select attrs.name,
attrs.type,
attrs.label,
dims.aw_name,
attrs.pers_cwm_name
from zpb_attributes_vl attrs,
zpb_dimensions dims
where attrs.dimension_id = l_dim_id and
dims.dimension_id = attrs.range_dim_id;
select meas.name meas,
meas.instance_id,
cubs.name cube,
cols.column_name,
meas.cube_id
from zpb_measures meas,
zpb_columns cols,
zpb_cubes cubs
where meas.cube_id = cubs.cube_id and
meas.column_id = cols.column_id and
cubs.bus_area_id = p_bus_area_id and
meas.type = l_meas_type
order by meas.name;
select meas.name meas,
meas.instance_id,
cubs.name cube,
cols.column_name,
meas.cube_id
from zpb_measures meas,
zpb_columns cols,
zpb_cubes cubs
where meas.cube_id = cubs.cube_id and
meas.column_id = cols.column_id and
cubs.bus_area_id = p_bus_area_id and
meas.type = l_meas_type and
cubs.name like 'ZPB' || to_char(p_user_id) || 'A' || to_char(p_bus_area_id) || '/_%' escape '/'
order by meas.name;
select dims.epb_id,
dims.aw_name
from zpb_cube_dims cds,
zpb_dimensions dims
where cds.dimension_id = dims.dimension_id
and cds.cube_id = l_cube_id;
select dvl.name,
dvl.is_owner_dim,
dvl.pers_cwm_name,
dvl.shar_cwm_name,
dvl.aw_name,
dvl.dimension_id,
(select count(*) from zpb_hierarchies where dimension_id = dvl.dimension_id and hier_type<>'NULL') hier_cnt,
dvl.epb_id
from zpb_dimensions_vl dvl
where bus_area_id = p_bus_area_id and
is_data_dim='YES'
order by is_owner_dim desc,
name;
select name,
hier_type,
epb_id,
tab1.table_name pers_table_name,
tab2.table_name shar_table_name,
hierarchy_id
from zpb_hierarchies_vl hier,
zpb_tables tab1,
zpb_tables tab2
where hier.dimension_id = l_dim_id and
hier.pers_table_id = tab1.table_id and
hier.shar_table_id = tab2.table_id;
select levs.name,
levs.epb_id,
levs.pers_cwm_name,
levs.shar_cwm_name
from zpb_levels_vl levs,
zpb_hier_level hrlv
where hrlv.level_id = levs.level_id and
hrlv.hier_id = l_hier_id
order by hrlv.level_order;
select attrs.name,
attrs.type,
attrs.label,
dims.aw_name,
attrs.pers_cwm_name
from zpb_attributes_vl attrs,
zpb_dimensions dims
where attrs.dimension_id = l_dim_id and
dims.dimension_id = attrs.range_dim_id;
select meas.name meas,
meas.instance_id,
cubs.name cube,
cols.column_name,
meas.cube_id
from zpb_measures meas,
zpb_columns cols,
zpb_cubes cubs
where meas.cube_id = cubs.cube_id and
meas.column_id = cols.column_id and
cubs.bus_area_id = p_bus_area_id and
meas.type = l_meas_type
order by meas.name;
select meas.name meas,
meas.instance_id,
cubs.name cube,
cols.column_name,
meas.cube_id
from zpb_measures meas,
zpb_columns cols,
zpb_cubes cubs
where meas.cube_id = cubs.cube_id and
meas.column_id = cols.column_id and
cubs.bus_area_id = p_bus_area_id and
meas.type = l_meas_type and
cubs.name like 'ZPB' || to_char(p_user_id) || 'A' || to_char(p_bus_area_id) || '/_%' escape '/'
order by meas.name;
select dims.epb_id,
dims.aw_name
from zpb_cube_dims cds,
zpb_dimensions dims
where cds.dimension_id = dims.dimension_id
and cds.cube_id = l_cube_id;
select min(USER_ID)
into l_user
from ZPB_USERS
where BUSINESS_AREA_ID = p_business_area;
select data_aw
into l_data_aw
from zpb_business_areas
where BUSINESS_AREA_ID = p_business_area;