We Create a view by using 2 tables for( ex.emp table and dept table) after that i changed some rows in the emp table what will happen in the view? whether the view also gets updated or not?
Type: Posts; User: amitkannan; Keyword(s):
We Create a view by using 2 tables for( ex.emp table and dept table) after that i changed some rows in the emp table what will happen in the view? whether the view also gets updated or not?
we can't use a procedure within a view ....view can be used within a procedure...
Alter table table_name MODIFY(houseno varchar2(30));