后台代码：大客户资料

导一点份大客户的资料--导一点份大客户的资料select * from atmp_acct select * from cust.serv_acct@to_ncashselect * from    cust.serv_history@to_ncash where USER_NAME='胡国显'1select * from    cust.acct@to_ncash where acct_id in (20063076,20067007,31187479）;2select * from    cust.cust@to_ncash;3select * from    cust.serv_credit_info@to_ncash;4select * from     cust.serv_acct@to_ncash;5select * from     acct.acct_item_731@to_ncash where  a.serv_id =b.serv_id  billing_cycle_id like ;6select * from     bill.acct_item_sd_311702@to_nbill ;9select * from     cashbill.acct_balance;7select * from     acct.balance_share_rule@to_ncash;8 object_id=acct_id--2create table atmp_acct as  select * from  cust.acct@to_ncash where acct_id in (20063076,20067007,31187479);select * from  atmp_acct;401000818999,401000242624,402008820520drop 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_historyselect *  from abtmp_custselect distinct passwd from abctmp_custselect * 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--4select * 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; --5select * 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--更新--6select * from  atmp_acct ;select * from     acct.acct_item_731@to_ncash;create table abctmp_acct_item_731 asselect 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;--7select distinct acct_id from  tmp_historyselect distinct cust_id  from tmp_historyselect * from atmp_acctselect * from     acct.abctmp_acct_balanceselect * from     acct.balance_share_rule@to_ncash where select * from acct.acct_balance@to_ncashcreate table abctmp_acct_balance as select a.* from acct.acct_balance@to_ncash a ,atmp_acct bwhere a.acct_id=b.acct_id;select * from abctmp_acct_balance--8create 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_idselect * from acct.balance_share_rule@to_ncash select * from abctmp_balance_share_rule--ggenxindrop table abctmp_balance_share_rule--9create 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 aselect * from cust.key_acct@to_ncash order by acct_id;select * from cust.cust @to_ncash