请问||这个符号在SQL语句中什么意思?是不是连接符?'insert into TMP_${TASK}_${BM}_${LATN}
select serv_id,SUBST_ID,SUM_MONTH,parent_item_id as DUE_INCOME_CODE,sum(charge) as charge,G_USER_TYPE
from EDA_${LATN}.rpt_item@SRHX a,TMP_${TASK}_${BM}_${LATN} b
where a.item_id = b.DUE_INCOME_CODE and a.item_id like ''SR%''
and length(a.parent_item_id) ='||to_char(n)||'
group by parent_item_id,G_USER_TYPE';
select serv_id,SUBST_ID,SUM_MONTH,parent_item_id as DUE_INCOME_CODE,sum(charge) as charge,G_USER_TYPE
from EDA_${LATN}.rpt_item@SRHX a,TMP_${TASK}_${BM}_${LATN} b
where a.item_id = b.DUE_INCOME_CODE and a.item_id like ''SR%''
and length(a.parent_item_id) ='||to_char(n)||'
group by parent_item_id,G_USER_TYPE';
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货