ORA-00972 标识符太长别名列名
问题描述：
我有一个类似的查询:
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).