我有一个问题,比如:
SELECT column as averyveryveryverylongalias (more than 30 characters)
FROM Table_name
它返回错误ORA-00972 identifier is too long,是否有任何技巧可以让它在不缩短别名的情况下工作?
谢谢
我有一个问题,比如:
SELECT column as averyveryveryverylongalias (more than 30 characters)
FROM Table_name
它返回错误ORA-00972 identifier is too long,是否有任何技巧可以让它在不缩短别名的情况下工作?
谢谢
不,在Oracle 12.2版之前,标识符的长度不允许超过30个字符.见the Oracle SQL Language Reference.
但是,from version 12.2 they can be up to 128 bytes long.(注意:字节,而不是字符).