在SQLSERVER中转换ORACLE,脚本出现异常了.
CREATE OR REPLACE PROCEDURE reptq1
(
cv_1 IN OUT SYS_REFCURSOR
)
AS
BEGIN OPEN cv_1 FOR
SELECT pub_id,
title_id,
price,
pubdate
FROM titles
WHERE price IS NOT NULL
ORDER BY pub_id
/*TODO:COMPUTE avg(price) BY pub_id*/
/*TODO:COMPUTE avg(price)*/;END;compute在oracle中不存在,刚刚百度了一下 也没有什么答案,希望帮忙。 如果改成ORACLE的语句 该怎么改呢? 谢谢.
CREATE OR REPLACE PROCEDURE reptq1
(
cv_1 IN OUT SYS_REFCURSOR
)
AS
BEGIN OPEN cv_1 FOR
SELECT pub_id,
title_id,
price,
pubdate
FROM titles
WHERE price IS NOT NULL
ORDER BY pub_id
/*TODO:COMPUTE avg(price) BY pub_id*/
/*TODO:COMPUTE avg(price)*/;END;compute在oracle中不存在,刚刚百度了一下 也没有什么答案,希望帮忙。 如果改成ORACLE的语句 该怎么改呢? 谢谢.
title_id,
price,
pubdate ,
avg(price)
FROM titles
WHERE price IS NOT NULL
group by pub_id
ORDER BY pub_id