I have a complex SQL command that needs to be run by a number of Users. I can create a View, put this SQL into the View and have the Users Select from the View I can select from the this DB object as if it was a table However I should NEVER insert via a View Oracle has a Materialized View which pre-reads the underling tables and build the records