Question: why views are used in oracle?
Answer: A view is a virtual table because you can use it like a table in your SQL queries. ... To be precise, a view only behaves like a table. And it is just a named query stored in the database. When you query data from a view, Oracle uses this stored query to retrieve the data from the underlying tables.