-1

Hy, can you help me whith this? I want to show the entire name of the columns(from the pivot). Ca this be possible? I know that tha maximum lenght is 30...

Ady Lacan
  • 59
  • 2
  • 7
  • Please, [not screenshots](http://meta.stackoverflow.com/questions/285551/why-may-i-not-upload-images-of-code-on-so-when-asking-a-question/285557#285557). – Aleksej Jun 08 '17 at 13:04

1 Answers1

0

If I understand well, you want to build a query with a column alias longer than 30 characters; if so, you only can in Oracle 12.2 and on.

With previous versions, this is what you get:

SQL> select 1 as "Alias with 30 characters -----"
  2  from dual;

Alias with 30 characters -----
------------------------------
                             1

SQL> select 1 as "Alias with 31 characters -----X"
  2  from dual;
select 1 as "Alias with 31 characters -----X"
            *
ERROR at line 1:
ORA-00972: identifier is too long
Aleksej
  • 22,443
  • 5
  • 33
  • 38