@JimLahey said:
My rage derives from the fact that Oracle allows me to create a view with all the columns present, yet doesn't allow anything other than a "select * " unless I basically alias all the columns. It's not a behaviour I was expecting from such an expensive and widely used product.
I know exactly what you mean, I couldn't believe that such behavior existed in Oracle back when I started on version 7. 10g was the last version I used, and it still lacked such basic functionality. Crazy.