我有以下SQL脚本,(Select To_Char(Bmret.Pricedate, 'dd-mm-yyyy') As Pricedate, Bmret.Bmval, Bmret.id, RANK() OVER (PARTITION BY bmret.id ORDER BY bmret.pricedate asc) AS rank
From Tab_A
我在包规范中有一个游标(涉及多个表连接)。我写它是因为当我编译它时,我想要管道function.But的返回类型,给出了下面的错误。[error] pls-00103 (6: 15): pls-00103: encountered the symbol "BEGIN" when expecting one of the following:
end function pragma procedure subtype type <an ide