in reply to How do I overcome ORA-00972: identifier is too long
If I recall corrrectly, identifiers in Oracle *can't* be more than 30 characters. So if the column name can't be >30 characters, why does your SELECT reference a (presumably non-existent) column name that is > 30 characters?