> -----Original Message----- > Yes, but my hands are tied in this situation. Are you allowed to define a sane column alias in the view? SQL> desc crap; Name Null? Type -------------------- -------- ---------------------------------------------- HELLO & GOODBYE VARCHAR2(100) SQL> set escape \ SQL> create view crap_view as select "HELLO \& GOODBYE" sane from crap; SQL> select * from crap_view; SANE --------------------------------- HELLO GOODBYE ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------