RE: Column alias giving ORA-00972

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Wed, 5 Apr 2006 13:59:07 -0400
Message-ID: <5A14AF34CFF8AD44A44891F7C9FF410506E8D861@usahm236.amer.corp.eds.com>

Oracle table column names are limed to 30 bytes, period.

However, since you are selecting off an existing table that would indicate that the real column name is less than or equal to 30 characters. Perhaps what you want is just a column label over 30 characters. Again the limit is 30.

• Long substitute col name but under 30 char UT1 > select rpad(dummy,40,' ') as somenameotherthantherealone from sys.dual;

SOMENAMEOTHERTHANTHEREALONE

---

X

• try to go past 30 char UT1 > c /one/oneplus 1* select rpad(dummy,40,' ') as somenameotherthantherealoneplus from sys.dual UT1 > / select rpad(dummy,40,' ') as somenameotherthantherealoneplus from sys.dual * ERROR at line 1: ORA-00972: identifier is too long

I think you are out of luck or I do not understand what you are really asking.
HTH -- Mark D Powell --

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jonathan Knight Sent: Wednesday, April 05, 2006 11:14 AM To: oracle-l_at_freelists.org
Subject: Column alias giving ORA-00972

All,
  Trying to ...

select
  col1
 ,col2 "I have a very long column name here" from tab;

... and I'm getting ORA-00972. The query is passed into a reporting subsystem which outputs to Excel and automagically emails the report to a vendor. They really want the long name. I think I already know the answer, but does anyone know of a way to force/fake/beat into submission the Oracle parser?

Thanks,
Jon Knight

---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Received on Wed Apr 05 2006 - 12:59:07 CDT