ORA-00972标识符的别名列名太长 [英] ORA-00972 identifier is too long alias column name

问题描述

我有一个类似的查询:

SELECT column as averyveryveryverylongalias (more than 30 characters)
   FROM Table_name

它返回错误 ORA-00972标识符太长，是否有任何提示可以使它工作而又不缩短别名?

it returns the error ORA-00972 identifier is too long , is there any tip to make it work without making the alias shorter?

谢谢

推荐答案

否，在Oracle 12.2版之前，标识符的长度不能超过30个字符.请参见 Oracle SQL语言参考.

No, prior to Oracle version 12.2, identifiers are not allowed to exceed 30 characters in length. See the Oracle SQL Language Reference.

但是，从版本开始 12.2它们的最大长度为128个字节.(注意:字节，而不是字符).

However, from version 12.2 they can be up to 128 bytes long. (Note: bytes, not characters).

这篇关于ORA-00972标识符的别名列名太长的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！