后台代码：大客户资料

导一点份大客户的资料
--导一点份大客户的资料
select * from atmp_acct 
select * from cust.serv_acct@to_ncash
select * from    cust.serv_history@to_ncash where USER_NAME='胡国显'1
select * from    cust.acct@to_ncash where acct_id in (20063076,20067007,31187479）;2
select * from    cust.cust@to_ncash;3
select * from    cust.serv_credit_info@to_ncash;4
select * from     cust.serv_acct@to_ncash;5
select * from     acct.acct_item_731@to_ncash where  a.serv_id =b.serv_id  billing_cycle_id like ;6
select * from     bill.acct_item_sd_311702@to_nbill ;9
select * from     cashbill.acct_balance;7
select * from     acct.balance_share_rule@to_ncash;8 object_id=acct_id
--2
create table atmp_acct as  select * from  cust.acct@to_ncash where acct_id in (20063076,20067007,31187479);
select * from  atmp_acct;401000818999,401000242624,402008820520
drop table atmp_acct
/*exp acct/qxb#1234  file=/oradata/dump/acct_item_type.dmp   tables=acct_item_type query=\"where party_role_id like \'1002\'\" STATISTICS=NONE compress=Y INDEXES=N*/  
--3用户对应多个账户，所以不能反过来 
create table abtmp_cust as select a.*  
from cust.cust@to_ncash a,tmp_history b where a.cust_id=b.cust_id ;
create table abtmp_cust as select a.*  
from cust.cust@to_ncash a,abctmp_acct b where a.cust_id=b.cust_id ;
select distinct cust_id from tmp_history
select *  from abtmp_cust
select distinct passwd from abctmp_cust
select * from  abctmp_serv_acct ;
select count(*) from abctmp_cust where cust_id in ('273101156069','273101153835','273101154723')
create table  abctmp_cust as select * from abtmp_cust where cust_id in ('273101156069','273101153835','273101154723')

drop table abctmp_cust
--4
select * from  atmp_acct ;
select * from  abctmp_cust ;
select * from    cust.serv_credit_info@to_ncash;
create table abctmp_serv_credit_info as select a.*  from   cust.serv_credit_info@to_ncash a, abctmp_serv_acct b   where a.serv_id=b.serv_id 
select * from abctmp_serv_credit_info;--更新 
drop table abctmp_serv_credit_info;
 
--5
select * from  atmp_acct ;
select * from  abctmp_cust ;
select * from    cust.serv_credit_info@to_ncash;
select * from     cust.serv_acct@to_ncash;
create table abctmp_serv_acct as select 
a.*        
from cust.serv_acct@to_ncash a,atmp_acct b where a.acct_id in (20063076,20067007,31187479)
select * from abctmp_serv_acct where  serv_id like '6%'
--drop table abctmp_serv_acct--更新
--6
select * from  atmp_acct ;
select * from     acct.acct_item_731@to_ncash;
create table abctmp_acct_item_731 as
select 
a.* from  acct.acct_item_731@to_ncash a, atmp_acct b where  a.acct_id =b.acct_id ;
select * from abctmp_acct_item_731;
--7
select distinct acct_id from  tmp_history
select distinct cust_id  from tmp_history
select * from atmp_acct
select * from     acct.abctmp_acct_balance
select * from     acct.balance_share_rule@to_ncash where 
select * from acct.acct_balance@to_ncash
create table abctmp_acct_balance as select a.* from acct.acct_balance@to_ncash a ,atmp_acct b
where a.acct_id=b.acct_id;
select * from abctmp_acct_balance
--8
create table abctmp_balance_share_rule as select a.* from     acct.balance_share_rule@to_ncash a,abctmp_serv_acct b where a.object_id=b.serv_id
select * from acct.balance_share_rule@to_ncash 
select * from abctmp_balance_share_rule--ggenxin
drop table abctmp_balance_share_rule
--9
create table abctmp_acct_item_sd_311702 as select a.* from  bill.acct_item_sd_311702@to_nbill a ,abctmp_serv_acct b where  a.acct_id=b.acct_id;
select * from abctmp_acct_item_sd_311702;
select a.*from bill.acct_item_sd_311702@to_nbill a
select * from cust.key_acct@to_ncash order by acct_id;
select * from cust.cust @to_ncash