Saved Bookmarks
| 1. |
What are views? When can a view be updated? |
|
Answer» A view is, in essence, a virtual table. It does not physically exist. Rather, it is created by a query joining one or more tables. In following condition a view can be updated : If it has only one base table. If select statement used in view contains group by clause then we cant update view. |
|