Column aliasing
- From: rjamya <rjamya@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 20 Jul 2012 08:16:52 -0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
