Interested to Buy Any Domain ? << Click Here >> for more details...
can we update a view which is created from two tables
- 11 Answers
- 33585 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
What will you get by the cursor attribute sql%notfound?
What is transaction control language (tcl)?
How to get unique records from a table?
Which command is used to delete a package?
What are inbuilt functions in sql?
What is the syntax to add a record to a table?
What is the purpose of using pl/sql?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
What is the command used to fetch first 5 characters of the string?
What is the command used to fetch the first 5 characters of a string?
What does closing a cursor do?
what are enums used for in mysql? : Sql dba
What does trigger mean in slang?
how would concatenate strings in mysql? : Sql dba
how do you login to mysql using unix shell? : Sql dba
