As an example, you might need to look at details of a book, such as ISBN, title, cost, retail, and author(s). Since a view acts like a table object, you can run select statements against the table.
In Oracle What would be the code to create the view of a table described above?
There are restrictions on inserts, updates and deletes when using a view. How is this a disadvantage? How is this an advantage?