ORA-00904:"CEILING":ORACLE 11G中的无效标识符 [英] ORA-00904: "CEILING": invalid identifier in ORACLE 11G

问题描述

在oracle 11g中进行上限抛出java.sql.SQLException:ORA-00904:"CEILING":无效的标识符. 直到现在使用的是Oracle 10G，现在我们升级到11G，之后我们收到"CEILING":无效标识符错误

ceiling in oracle 11g throws java.sql.SQLException: ORA-00904: "CEILING": invalid identifier. Till now are used Oracle 10G, now we upgraded to 11G,afterthe we are getting ""CEILING": invalid identifier" error

请对此提供任何帮助.

推荐答案

没有功能CEILING属于任何版本的任何现有Oracle数据库安装的一部分.

There is no function CEILING that is part of any stock Oracle database install of any version.

如果在10g数据库中使用函数CEILING，则表明它是用户定义的函数.如果该功能在11g中不存在，则需要在其中创建它.

If you are using a function CEILING in your 10g database, that implies that it is a user-defined function. If that function doesn't exist in 11g, you'd need to create it there.

Oracle确实有一个函数CEIL，该函数接受一个数字并四舍五入到下一个最大整数.如果这就是您要做的一切，那么使用内置函数比编写自己的包装函数可能更有意义.

Oracle does have a function CEIL that takes a number and rounds up to the next highest integer. If that's all you are doing, it probably makes more sense to use the built-in function rather than writing your own wrapper function.

这篇关于ORA-00904:"CEILING":ORACLE 11G中的无效标识符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！