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)

Other related posts: