Display long/meaningful column names on export to excel

[ori marko]

I can export a Oracle (12.1) SQL results to excel using PL/SQL developer

But sometimes the requirements are to give a meaningful name for the column/header

for example "total amount for previous 21 days"

Obviously, it exceed 30 characters and gets ORA-00972 identifier is too long

Can I export with different column names without manually renaming in output excel?

 

[Marco Kalter]

On Oracle 12.1 this is not possible. On Oracle 12.2 and later you can use long identifiers.