Assume I created
CREATE VIEW OFFICEINFO AS
SELECT OFFICE, CITY, REGION
oracle DB, a quick glimpse:
No Triggers, you can imagine a view as a pointer to the table. It reflects the data in table in real time, if juss store the query
No, but you can use a materialized view.
Pro, you can use the view as an aggregator from table/s data , but it does not occupy space in database, cons: if you change table/s structure the view will become invalid until recompilation