Column alias giving ORA-00972

From: Jonathan Knight <knightjck_work_at_yahoo.com>
Date: Wed, 5 Apr 2006 08:14:28 -0700 (PDT)
Message-ID: <20060405151428.46783.qmail@web60620.mail.yahoo.com>

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

Received on Wed Apr 05 2006 - 10:14:28 CDT