Hi Experts,
I have this below issue.
ORA-00972: identifier is too long
with data0(id, val) as
(
select 1, 'One' from dual
union all
select 2, 'Two' from dual
)
--select id, val from data0 --This works fine.
select id as "I am selecting the id that exceeds", val as "I am selecting val" from data0 --This fails
I understand that there is limitation on the column length in Oracle. But is there anyway to get it done ?
Actually, we are saving the query results in .xlsx format by pl/sql code. We need the column name to be the same (some name that exceeds limit 30 ) when someone opens the .xlsx sheet.
Can someone please help me on this ?
Regards,
Ranagal