variable StartDate varchar2(10); exec StartDate := '2014-01-01'; select * from t where a = StartDate
variable StartDate varchar2(10); exec StartDate := '2014-01-01'; select * from t where a = StartDate我要做在REPORT BUILDER里面的,你这个代码他显示出错
variable StartDate varchar2(10); exec StartDate := '2014-01-01'; select * from t where a = StartDate我要做在REPORT BUILDER里面的,你这个代码他显示出错 不好意思,我没用过你这个报表,不知道你这个报表能不能传参
select * from (SELECT I_TERM_NO ,I_WS_FAC_CD ,I_FAC_CD ,I_IND_MNTH , I_IND_DEST_CD ,I_IND_DEST_DESC from GSC9048_PRT WHERE I_IND_MNTH = '201408' AND I_TERM_NO = '110' and I_IND_DEST_CD not in ('dummy ') GROUP BY I_TERM_NO,I_WS_FAC_CD,I_FAC_CD,I_IND_MNTH, I_IND_DEST_CD,I_IND_DEST_DESC ) a left join ( SELECT I_LINE_CD ,ROUND(SUM(I_IN_SETUP_TIME * I_CYCLE_TIME) / 3600, 1) duanqu FROM T_GSC_SELF_MACHINE_TR group by I_LINE_CD ) b on a.I_IND_DEST_CD = b.I_LINE_CD ORDER BY I_IND_DEST_CD DESC 其中我那个I_IND_MNTH = '201408' 中的201408想设置成一个变量来传递,应该怎么写啊在ORACLE里!
variable StartDate varchar2(10); exec StartDate := '2014-01-01'; select * from t where a = StartDate我要做在REPORT BUILDER里面的,你这个代码他显示出错 不好意思,我没用过你这个报表,不知道你这个报表能不能传参恩,没用过ORACLE现在他的变量传不过去
select * from (SELECT I_TERM_NO ,I_WS_FAC_CD ,I_FAC_CD ,I_IND_MNTH , I_IND_DEST_CD ,I_IND_DEST_DESC from GSC9048_PRT WHERE I_IND_MNTH = '201408' AND I_TERM_NO = '110' and I_IND_DEST_CD not in ('dummy ') GROUP BY I_TERM_NO,I_WS_FAC_CD,I_FAC_CD,I_IND_MNTH, I_IND_DEST_CD,I_IND_DEST_DESC ) a left join ( SELECT I_LINE_CD ,ROUND(SUM(I_IN_SETUP_TIME * I_CYCLE_TIME) / 3600, 1) duanqu FROM T_GSC_SELF_MACHINE_TR group by I_LINE_CD ) b on a.I_IND_DEST_CD = b.I_LINE_CD ORDER BY I_IND_DEST_CD DESC 其中我那个I_IND_MNTH = '201408' 中的201408想设置成一个变量来传递,应该怎么写啊在ORACLE里!
select * from (SELECT I_TERM_NO ,I_WS_FAC_CD ,I_FAC_CD ,I_IND_MNTH , I_IND_DEST_CD ,I_IND_DEST_DESC from GSC9048_PRT WHERE I_IND_MNTH = '201408' AND I_TERM_NO = '110' and I_IND_DEST_CD not in ('dummy ') GROUP BY I_TERM_NO,I_WS_FAC_CD,I_FAC_CD,I_IND_MNTH, I_IND_DEST_CD,I_IND_DEST_DESC ) a left join ( SELECT I_LINE_CD ,ROUND(SUM(I_IN_SETUP_TIME * I_CYCLE_TIME) / 3600, 1) duanqu FROM T_GSC_SELF_MACHINE_TR group by I_LINE_CD ) b on a.I_IND_DEST_CD = b.I_LINE_CD ORDER BY I_IND_DEST_CD DESC 其中我那个I_IND_MNTH = '201408' 中的201408想设置成一个变量来传递,应该怎么写啊在ORACLE里!
exec StartDate := '2014-01-01';
select * from t where a = StartDate
exec StartDate := '2014-01-01';
select * from t where a = StartDate我要做在REPORT BUILDER里面的,你这个代码他显示出错
exec StartDate := '2014-01-01';
select * from t where a = StartDate我要做在REPORT BUILDER里面的,你这个代码他显示出错
不好意思,我没用过你这个报表,不知道你这个报表能不能传参
I_TERM_NO
,I_WS_FAC_CD
,I_FAC_CD
,I_IND_MNTH
, I_IND_DEST_CD
,I_IND_DEST_DESC
from GSC9048_PRT
WHERE
I_IND_MNTH = '201408'
AND I_TERM_NO = '110'
and I_IND_DEST_CD not in ('dummy ')
GROUP BY I_TERM_NO,I_WS_FAC_CD,I_FAC_CD,I_IND_MNTH, I_IND_DEST_CD,I_IND_DEST_DESC )
a left join ( SELECT I_LINE_CD
,ROUND(SUM(I_IN_SETUP_TIME * I_CYCLE_TIME) / 3600, 1) duanqu FROM T_GSC_SELF_MACHINE_TR group by I_LINE_CD ) b
on a.I_IND_DEST_CD = b.I_LINE_CD
ORDER BY I_IND_DEST_CD DESC
其中我那个I_IND_MNTH = '201408' 中的201408想设置成一个变量来传递,应该怎么写啊在ORACLE里!
exec StartDate := '2014-01-01';
select * from t where a = StartDate我要做在REPORT BUILDER里面的,你这个代码他显示出错
不好意思,我没用过你这个报表,不知道你这个报表能不能传参恩,没用过ORACLE现在他的变量传不过去
,I_WS_FAC_CD
,I_FAC_CD
,I_IND_MNTH
, I_IND_DEST_CD
,I_IND_DEST_DESC
from GSC9048_PRT
WHERE
I_IND_MNTH = '201408'
AND I_TERM_NO = '110'
and I_IND_DEST_CD not in ('dummy ')
GROUP BY I_TERM_NO,I_WS_FAC_CD,I_FAC_CD,I_IND_MNTH, I_IND_DEST_CD,I_IND_DEST_DESC )
a left join ( SELECT I_LINE_CD
,ROUND(SUM(I_IN_SETUP_TIME * I_CYCLE_TIME) / 3600, 1) duanqu FROM T_GSC_SELF_MACHINE_TR group by I_LINE_CD ) b
on a.I_IND_DEST_CD = b.I_LINE_CD
ORDER BY I_IND_DEST_CD DESC
其中我那个I_IND_MNTH = '201408' 中的201408想设置成一个变量来传递,应该怎么写啊在ORACLE里!
,I_FAC_CD
,I_IND_MNTH
, I_IND_DEST_CD
,I_IND_DEST_DESC
from GSC9048_PRT
WHERE
I_IND_MNTH = '201408'
AND I_TERM_NO = '110'
and I_IND_DEST_CD not in ('dummy ')
GROUP BY I_TERM_NO,I_WS_FAC_CD,I_FAC_CD,I_IND_MNTH, I_IND_DEST_CD,I_IND_DEST_DESC )
a left join ( SELECT I_LINE_CD
,ROUND(SUM(I_IN_SETUP_TIME * I_CYCLE_TIME) / 3600, 1) duanqu FROM T_GSC_SELF_MACHINE_TR group by I_LINE_CD ) b
on a.I_IND_DEST_CD = b.I_LINE_CD
ORDER BY I_IND_DEST_CD DESC
其中我那个I_IND_MNTH = '201408' 中的201408想设置成一个变量来传递,应该怎么写啊在ORACLE里!