1、drop table a;drop table b;create table a asselect o_bsc.name bsc_name,c_bts.cell_id cell_id,to_number(o_bsc.object_instance) bsc_id,c_bts.la_id_lac lac,c_bts.segment_name segment_name,c_bts.segment_id segment_id,o_bcf.object_instance BCF,c_trx.dap_id dap_id, decode(c_bts.gprs_enabled,0,N,1,Y) gena,d
2、ecode(c_bts.egprs_enabled,0,N,1,Y) egena,c_bts.nsei nsei,c_bts.dedicated_gprs_capacity cded,c_bts.default_gprs_capacity cdef,to_number(o_trx.object_instance) trx_id,c_trx.initial_frequency freq,c_bts.bsic_ncc ncc,c_bts.bsic_bcc bcc,decode(c_trx.ch_0_type,0,TCHF,1,TCHH,2,TCHD,3,SDCCH,4,MBCCH,5,MBCCHC
3、,6,CCH,7,MBCCB,8,SDCCB,9,Not used,10,E-RACH,12,PCCCH,13,PBCCH) ch0,decode(c_trx.ch_1_type,0,TCHF,1,TCHH,2,TCHD,3,SDCCH,4,MBCCH,5,MBCCHC,6,CCH,7,MBCCB,8,SDCCB,9,Not used,10,E-RACH,12,PCCCH,13,PBCCH) ch1,decode(c_trx.ch_2_type,0,TCHF,1,TCHH,2,TCHD,3,SDCCH,4,MBCCH,5,MBCCHC,6,CCH,7,MBCCB,8,SDCCB,9,Not u
4、sed,10,E-RACH,12,PCCCH,13,PBCCH) ch2,decode(c_trx.ch_3_type,0,TCHF,1,TCHH,2,TCHD,3,SDCCH,4,MBCCH,5,MBCCHC,6,CCH,7,MBCCB,8,SDCCB,9,Not used,10,E-RACH,12,PCCCH,13,PBCCH) ch3,decode(c_trx.ch_4_type,0,TCHF,1,TCHH,2,TCHD,3,SDCCH,4,MBCCH,5,MBCCHC,6,CCH,7,MBCCB,8,SDCCB,9,Not used,10,E-RACH,12,PCCCH,13,PBCC
5、H) ch4,decode(c_trx.ch_5_type,0,TCHF,1,TCHH,2,TCHD,3,SDCCH,4,MBCCH,5,MBCCHC,6,CCH,7,MBCCB,8,SDCCB,9,Not used,10,E-RACH,12,PCCCH,13,PBCCH) ch5,decode(c_trx.ch_6_type,0,TCHF,1,TCHH,2,TCHD,3,SDCCH,4,MBCCH,5,MBCCHC,6,CCH,7,MBCCB,8,SDCCB,9,Not used,10,E-RACH,12,PCCCH,13,PBCCH) ch6,decode(c_trx.ch_7_type,
6、0,TCHF,1,TCHH,2,TCHD,3,SDCCH,4,MBCCH,5,MBCCHC,6,CCH,7,MBCCB,8,SDCCB,9,Not used,10,E-RACH,12,PCCCH,13,PBCCH) ch7,-c_trx.e_trx_ind,decode(o_bcf.bcf_type,0,2nd Gen,1,TALK-FAMILY,2,PrimeSite,3,METROSITE,4,InSite,5,ULTRASITE,FLEXI EDGE) SITETYPE,-decode(c_trx.ch_7_admin_state,-1,bad,1,good) trx_state,dec
7、ode(c_trx.abilities,1,EDGE,0,TRX) trx_type,decode(c_trx.gprs_enabled_trx,0,N,1,Y) gtrx,c_trx.tsc tsc,c_trx.ch_0_pcm ch_0_pcm,c_trx.ch_0_tsl ch_0_tsl,c_trx.ch_0_subslot ch_0_subslot,c_trx.lapd_link_name lapd_link_name,c_trx.lapd_link_number lapd_link_number from c_trx, objects o_trx, objects o_bts, o
8、bjects o_bsc, c_bts,objects o_bcfwhere c_trx.int_id=o_trx.int_id and o_trx.parent_int_id=o_bts.int_id and o_bts.int_id=c_bts.int_id and c_bts.bsc_int_id=o_bsc.int_idand o_bcf.int_id=o_bts.parent_int_id and o_bcf.parent_int_id=o_bsc.int_idand c_trx.conf_name= and c_bts.conf_name=and o_bsc.name Like S
9、ZBSC%order by o_bsc.name,c_bts.cell_id,to_number(o_trx.object_instance);create table b asselectlapd.bsc_id bsc_id, lapd.lapd_link_name,lapd.lapd_link_number,lapd.sapi sapi,lapd.tei tei,lapd.bit_rate br,lapd.timeslot_pcm pcm,lapd.timeslot_tsl tsl,lapd.subslot subslotfrom c_lapd_link lapd;select a.cell_id,a.bsc_name,a.segment_name,a.bcf,a.sitetype,a.dap_id,a.trx_id,a.freq,a.tsc,a.ch0,a.ch1,a.ch2,a.ch3,a.ch4,a.ch5,a.ch6,a.ch7,a.ch_0_pcm,a.ch_0_tsl,a.lapd_link_name,b.sapi,b.tei,b.br,b.pcm,b.tsl,b.subslotfrom a,bwhere a.lapd_link_number=b.lapd_link_numberand a.bsc_id=b.bsc_id
