下面一个sql在pl/sql下可以执行,但是pro*c代码中预编译却出现错误
1. 表结构如下:
table1
ID VALUE1 VALUE2
table2
ID VALUE32.sql语句如下
SELECT A.ID ,
A.VALUE1 ,
A.VALUE2
B.value3 ,
COUNT(*)over(PARTITION BY A.ID)
FROM table1 A, table2 B
WHERE A.ID = B.ID(+);3.错误如下:
COUNT(*)over(PARTITION BY A.ID)
...........................1
PCC-S-02201, Encountered the symbol "(" when expecting one of the following: , into, from,然道是pro*c不支持over,不太可能吧??
1. 表结构如下:
table1
ID VALUE1 VALUE2
table2
ID VALUE32.sql语句如下
SELECT A.ID ,
A.VALUE1 ,
A.VALUE2
B.value3 ,
COUNT(*)over(PARTITION BY A.ID)
FROM table1 A, table2 B
WHERE A.ID = B.ID(+);3.错误如下:
COUNT(*)over(PARTITION BY A.ID)
...........................1
PCC-S-02201, Encountered the symbol "(" when expecting one of the following: , into, from,然道是pro*c不支持over,不太可能吧??
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货