ORA-00972 identifier is too long alias column name

Question

hi dears,

i have a query like :

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

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

Thanks

Answer 1

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

Answer 2

If there would have been a way, this guy would have known so and proposed a solution.

There is no way to make it longer.