Oracle Views

Back To Basics: Views, what exactly are they?

Views are strange objects.  They look like tables, can be queried like a table, but they don't store any actual data.  Think of them as a virtual table which has pointers back to the source tables.  Views can combine data from one or more tables via joins just like a select statement. Using...