RE: A view is created on a table then i dropped the ba...
YEs The view will work fine.When we Re-create table with the same name view will work.If the table has some records entered then the old view also display the new record.so it is completely work.
RE: A view is created on a table then i dropped the ba...
It depends how the view is accessed first time. If you access the viewfirst in a plsql programm plsql will recompile invalid objectsauomatically. On the other side if you access the view first thou JDBCit will not be recompiled an remains invald.
RE: A view is created on a table then i dropped the ba...
yes the view will work if the base table is dropped and again created with the same name and same records. it must have all the initial records new records can be added though to the newly created table. hte new records will be show in the view too. regards sudha.
