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

问题描述

我有一个类似的查询:

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

它返回错误 ORA-00972 identifier is too long ，是否有任何提示可以在不缩短别名的情况下使其正常工作?

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屋！