Column aliasing

From: rjamya <rjamya_at_gmail.com>
Date: Fri, 20 Jul 2012 08:16:52 -0400
Message-ID: <CAGurbTPPeNAS_KK-uibS-tBsRFCDxivLnM0Z9kEk2jXq2V8yzw_at_mail.gmail.com>



Hi all,

Is there a way to detect column aliasing (or double-aliasing) in view scripts other than manual look over? Here is a classic example of double aliasing that i see in some of the code

create view view1 (col1, col2, col3) as select column_1 as a, column_2 as b, column_3 as c from blah blah;

so in select column_1 is aliased as "A", which is exposed in the view as "COL1". I know this is no harm, but sure confuses the heck when you read something when your view had 40+ columns and your view definition has UNION ALL etc.

Just curious (version 11.2)
Raj

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jul 20 2012 - 07:16:52 CDT

Original text of this message