Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: alias for long object name
On Fri, 25 Jul 2003 17:53:29 GMT, Karsten Farrell
<kfarrell_at_belgariad.com> wrote:
...
>If I add a column to the table (or drop a column), I have to remember to
>update the view as well (unless it's simply select *).
...
'select *' is converted to 'select col1,col2,...' in the stored view
definition, so if you drop a column for instance, the view will become
invalid and won't compile.
Jaap. Received on Sat Jul 26 2003 - 11:50:14 CDT