sql文中一个字段的别名不要超过30个字符,否则会报identifier is too long错误。
测试:
select 'a' as AAAAAAAAAA_AAAAAAAAA_AAAAAAAAAB from dual;
错误:
ORA-00972:identifier is too long
?