Interested to Buy Any Domain ? << Click Here >> for more details...
can we update a view which is created from two tables
- 11 Answers
- 34029 Views
- I also Faced
- E-Mail Answers
Answer Posted / sankar
It is not possible to update a view which is created from
two tables.Actually when we update any viewtha first the
view has been updated followed by the base table.If we use
instead of trigger then the base be table will updated
first not the view.Because the view is stored in database
as a query.Once the base table will be changed,the view
query will hit the base table and reflects the changes.But
I think that's not the desired answer.
| Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
Is sql easier than java?
what are the advantages and disadvantages of views in a database? : Sql dba
Can we use ddl statements in stored procedure sql server?
What is primary key and foreign key with example?
what are all types of user defined functions? : Sql dba
Are stored procedures faster than queries?
how to add a new column to an existing table in mysql? : Sql dba
What does stand for in sql?
What is sqlite used for?
how to select unique records from a table? : Sql dba
How can we solve sql error: ora-00904: invalid identifier?
Can we join tables without foreign key?
Which join is like inner join?
What is a field in a database?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
