Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Possible: View = "Select * ..." ?
All you have to do is recompile the view after altering the table
definition:
alter view VIEW_NAME compile;