？存储过程中

[joinsearch]

SELECT
CASE node_addr
WHEN '68.38.9@10.68.101.9' then '1'
when '3.38.61@10.107.203.61' then '3'
when '3.38.102@10.107.203.102' then '4'
else '5'
end
from CSC_TRAFFIC_DAY_10_8_2004

这个在存储过程中怎么写呢？〉

[joinsearch]

是不是一定得加into啊？

[AFIC]

你知道了还问啥……

[joinsearch]

oracle存储过程中，编译以下代码时：


SELECT
SUM(CASE WHEN KT_KHXX.K_NXQZL<5 THEN 1 ELSE 0 END ) 小于5,
SUM(CASE WHEN KT_KHXX.K_NXQZL>5 and KT_KHXX.K_NXQZL < 10 THEN 1 ELSE 0 END ) 5-10,
SUM(CASE WHEN KT_KHXX.K_NXQZL>10 and KT_KHXX.K_NXQZL < 15 THEN 1 ELSE 0 END ) 10-15 ,
SUM(CASE WHEN KT_KHXX.K_NXQZL>15 and KT_KHXX.K_NXQZL < 20 THEN 1 ELSE 0 END ) 15-20 ,
SUM(CASE WHEN KT_KHXX.K_NXQZL>20 and KT_KHXX.K_NXQZL < 25 THEN 1 ELSE 0 END ) 20-25 ,
SUM(CASE WHEN KT_KHXX.K_NXQZL>25 THEN 1 ELSE 0 END ) 大于25
into n1,n2,n3,n4,n5,n6
FROM KT_KHXX;

提示错误：未找到预期from关键字！这是怎么回事？语法应该没错吧？

[wiler]

SELECT
SUM(CASE WHEN KT_KHXX.K_NXQZL<5 THEN 1 ELSE 0 END ) "小于5",
SUM(CASE WHEN KT_KHXX.K_NXQZL>5 and KT_KHXX.K_NXQZL < 10 THEN 1 ELSE 0 END ) "5-10",
SUM(CASE WHEN KT_KHXX.K_NXQZL>10 and KT_KHXX.K_NXQZL < 15 THEN 1 ELSE 0 END ) "10-15" ,
SUM(CASE WHEN KT_KHXX.K_NXQZL>15 and KT_KHXX.K_NXQZL < 20 THEN 1 ELSE 0 END ) "15-20" ,
SUM(CASE WHEN KT_KHXX.K_NXQZL>20 and KT_KHXX.K_NXQZL < 25 THEN 1 ELSE 0 END ) "20-25" ,
SUM(CASE WHEN KT_KHXX.K_NXQZL>25 THEN 1 ELSE 0 END ) "大于25"
into n1,n2,n3,n4,n5,n6
FROM KT_KHXX;

字段不允许有非法字符，用双引号引起来就可以

[Eric_1999]

明显有语法错误，别名加上“”