? SQL .(Oracle 9.2.0.1.0. Win2003). . SQL Plus . :
rollup(cg id_par,cg id,ts id_client,tvof id_tov_group_top,tvof id_tov_group,tvof id,ts id) *
:
:
:
- . . . 1 .- . . . Oracle - . . .
) id_tov_group_top,nvl(tvof id_tov_assort,
id=tvof id_tov_group_top ),
(ts oborot) oborot,grouping_id(cg id_par,cg id,ts id_client,tvof id_tov_assort_top,tvof id_tov_group,tvof id,ts id) grp_mask
tvost id t_id,tvost id_tov_office,d id,d id_client,tm date_doc,tm cnt_ost tm_cnt_ost,tm cnt_rls tm_cnt_rls,tm cost_ost tm_cost_ost,tm oborot,tvost cnt_ost,tvost cnt_rls,tvost be_ost
tov_ost tvost,doc d,doc_tab dt,tov_move tm
tvost id t_id tvost id_tov_office d id d id_client tm date_doc tm cnt_ost tm_cnt_ost tm cnt_rls tm_cnt_rls tm be_ost tm_cost_ost tm oborot tvost cnt_ost tvost cnt_rls tvost cost_ost
tov_ost tvost doc d tov_act tm
tm id_doc=d id) ts,tov_office tvof believe_client_group_top cg,client_group_links cgl
ts id_tov_office =tvof id
rollup(cg id_par,cg id,ts id_client,tvof id_tov_assort_top,tvof id_tov_assort,tvof id,ts id)
. . . . :
. . . . :
... . . )) . . 1. - ORA-600. . ... - .
. .
. . 9.2.0.7 - :)
. :AND nvl(i_id_tov_office,0) IN (0,tvof id) i_id_tov_office - .
Forex Groups - Tips on Trading
Related article:
http://www.sql.ru/forum/actualthread.aspx?bid=3&tid=455384
comments | Add comment | Report as Spam
|