Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
MIX
SELECT --rks.d_start, rks.d_finish "смена", rks.nr_polz "№польз", rks.name_polz "имя польз" , decode (rks.sposyb, 'QTR', 'терминал', 'печать') "способ рал.", count(rks.strok) "палл", sum(rks.karton) "ящ.", sum (rks.strok) "строк" FROM (select --sh.ship_pl_lu_nr nr_pal, to_char(sh.date_started,'yyyy-mm-dd hh24:mi') d_start, to_char(sh.date_finished,'yyyy-mm-dd hh24:mi')d_finish, su.user_nr nr_polz, su.name name_polz, sh.app_name sposyb, sum(il_kart) karton, count(sh.ship_pl_lu_id) strok FROM ship_pl_loadunits_hist sh, qcm_sysusers su, (SELECT slu.ship_pl_lu_id, round(lc.BU_QUANTITY_LOADED / pl.bu_quantity,1) il_kart --su.user_nr polz_l FROM SHIP_PL_LOADUNITS_HIST SLU, QWHV_SHIP_PL_LU_CONTENTS_ALL LC, qcm_package_levels pl --qcm_sysusers su where SLU.LU_TYPE = 'PL' --and su.user_id = slu.user_finished and slu.ship_pl_lu_id = lc.SHIP_PL_LU_ID and lc.PACKAGE_ID = pl.package_id and pl.level_nr = '1') kart where kart.ship_pl_lu_id = sh.ship_pl_lu_id and su.user_id = sh.user_finished group by sh.ship_pl_lu_nr, sh.date_started, sh.date_finished, su.user_nr, su.name, sh.app_name, sh.ship_pl_lu_id)RKS where rks.d_finish >= '2010-12-01' group by --rks.d_start, rks.d_finish, rks.nr_polz, rks.name_polz, rks.sposyb
run
|
edit
|
history
|
help
0
Srinivas
4
Bcom
PL/SQL declaracionVariables
wq1
create table
create table employees as e. No, e. Name., e. Phone no, e. Salary
Understanding while loop
testing
Srinivas