for x in
( select rpad( a.name, 30 ) ||
to_char( b.value-a.value, '9,999,999' ) ||
to_char( c.value-b.value, '9,999,999' ) ||
to_char( ( (c.value-b.value)-(b.value-a.value)), '9,999,999' ) data
from run_stats a, run_stats b, run_stats c
where a.name = b.name
and b.name = c.name
and a.runid = 'before'
and b.runid = 'after 1'
and c.runid = 'after 2'
and (c.value-a.value) > 0
and abs( (c.value-b.value) - (b.value-a.value) )
> p_difference_threshold
order by abs( (c.value-b.value)-(b.value-a.value))
) loop
dbms_output.put_line( x.data );
end loop;show error
sql statement ignored 红色行
( select rpad( a.name, 30 ) ||
to_char( b.value-a.value, '9,999,999' ) ||
to_char( c.value-b.value, '9,999,999' ) ||
to_char( ( (c.value-b.value)-(b.value-a.value)), '9,999,999' ) data
from run_stats a, run_stats b, run_stats c
where a.name = b.name
and b.name = c.name
and a.runid = 'before'
and b.runid = 'after 1'
and c.runid = 'after 2'
and (c.value-a.value) > 0
and abs( (c.value-b.value) - (b.value-a.value) )
> p_difference_threshold
order by abs( (c.value-b.value)-(b.value-a.value))
) loop
dbms_output.put_line( x.data );
end loop;show error
sql statement ignored 红色行
解决方案 »
- update语句执行计划有问题
- 如何写SQL语句查询任一月份分数不超过100,并且连续三个月不超过270这样的语句
- 求教关于联合查询中的问题!!!
- ~~~~~~~急急急急急 高手赐教 CODE 万分感谢 在线等 ~~~~~~~~
- Oracle8i的备份问题!!! (可惜小妹现无分可送,感谢!!!)
- 请问高手,怎么样将下列的N条记录转换成一行呀,在线给分
- ★★★很弱智的问题,怎么新建一个方案?(在线,马上给分,谢谢)
- Oralce9i 有没有可以创建数据库,创建表,删除表等操作的图形界面?
- 急!关于用full join产生sql语句报错的问题,请高手赐教!!!
- 关于management server 的问题
- 关于undo_retention
- oracle安装问题(redhat5.3 + oracle10g)
好像rpad函数还有个填充参数吧,rapd(a.name,'*',30)不知道对不对,初学
应该没问题的,主要看一下有没特殊的不可见字符导致编译错误
to_char( b.value-a.value, '9,999,999' ) ||
to_char( c.value-b.value, '9,999,999' ) || 把后面的||都去掉.
你这个又不是动态sql,不需要用连接符
oracle QQ群:54775466
欢迎大家来一起探讨。