这是Informix的写法,如何改为Oracle的写法,搞了半天,搞不定:
select
a.int_id,
a.omc_id,
a.timestamp,
a.tkgp_name,
a.imap_tgdirection,
a.tkgp_sig_type,
a.imap_opc,
a.imap_dpc,
c.dsp_name,
sum(b.spm_no),
d.msc_name,
a.fdn
from
c_hua_tkgp_info a,
c_hua_tkgp_Circuit b,
c_hua_MSCServerM3UADE c,
c_hua_msc_info d
where
a.imap_tg = b.imap_tg and
a.omc_id = b.omc_id and
a.omc_id = c.omc_id and
c.omc_id = d.omc_id and
a.imap_dpc = c.imap_dpc and
a.msc_fdn = d.fdn and
c.msc_fdn = d.fdn and
b.msc_fdn = d.fdn and
a.timestamp = b.timestamp and
b.timestamp = c.timestamp and
c.timestamp = d.timestamp
group by 1,2,3,4,5,6,7,8,9,11,12
select
a.int_id,
a.omc_id,
a.timestamp,
a.tkgp_name,
a.imap_tgdirection,
a.tkgp_sig_type,
a.imap_opc,
a.imap_dpc,
c.dsp_name,
sum(b.spm_no),
d.msc_name,
a.fdn
from
c_hua_tkgp_info a,
c_hua_tkgp_Circuit b,
c_hua_MSCServerM3UADE c,
c_hua_msc_info d
where
a.imap_tg = b.imap_tg and
a.omc_id = b.omc_id and
a.omc_id = c.omc_id and
c.omc_id = d.omc_id and
a.imap_dpc = c.imap_dpc and
a.msc_fdn = d.fdn and
c.msc_fdn = d.fdn and
b.msc_fdn = d.fdn and
a.timestamp = b.timestamp and
b.timestamp = c.timestamp and
c.timestamp = d.timestamp
group by 1,2,3,4,5,6,7,8,9,11,12
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货