RE: Column alias giving ORA-00972

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Wed, 5 Apr 2006 13:20:25 -0400
Message-ID: <F4C27E77F7A33E4CA98C19A9DC6722A2CDF87F@EXCHANGE.corp.perceptron.com>

Create your own header?

Select 'col1', 'I have a very long column name here' from dual UNION
select
  col1
,col2

from tab;

-----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:20:25 CDT