Habib Ali

• May 9th, 2016

A view (typically a complex query containing Joins & Aggregates) which stores its result in a DB Table. Can be cached for faster performance. Its highly used in Data Warehousing Environments, but use it carefully as it has lot of restrictions based on clauses and the underlying query

sachin rasal

• Dec 11th, 2015

Materialised view - A table on a disk that contains the result set of a query

Non-materiased view - A query that pulls data from the underlying table

Answer Question  Select Best Answer

 Error_type      return character   Error_code      return number   Error_text       return char   Dbms_error_code   return no.   Dbms_error_text     return char

sandeep5580

 Profile Answers by sandeep5580 Questions by sandeep5580

• Mar 29th, 2008

Well i am not pretty sure about this. I think we can use sqlerrm to trap an error.Thanks.Sandeep

Answer Question  Select Best Answer

A View can be updated/deleted/inserted if it has only one base table if the view is based on columns from one or more tables then insert, update and delete is not possible.

Maheswara Raju. Varakavi

• Aug 29th, 2016

If a view is updated, deleted , or inserted will the changes be reflected on the base table? YES--> If it is in the case of simple view (which consists only one base table). NO---->If it is in the c...

Mahendra K Garnayak

• Jun 7th, 2016

Thanks M.R. Varakavi for providing a valuable information.
could you please confirm in instead of trigger action will be performed on which table in case of join condition

Answer Question  Select Best Answer