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,
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-lReceived on Fri Jul 20 2012 - 07:16:52 CDT