Learning is not a spectator sport
Connor McDonald on SQL and the Oracle Database
Tag: views
Views as “stored text”
You’ll often see comments that views are not copies of the data, they are merely the stored text of a query that defines. This is by and large true, but don’t forget, this is not the same as saying we simply take whatever text…
views in 12c
Observed an interesting idiosyncracy in the creation of views in 12c (this is in a pluggable database, but not confirmed whether this is related or not). This database was upgraded from 11.2 without incident…until we came to replace one of the existing views. SQL>…
