proc-sql-view specifies the name for the PROC SQL view that you are creating. ... a connection is made and the libref ACCREC is assigned to an ORACLE database. create view proclib.view1 as select * ...

This article explores the internals of materialized views and demonstrates how to precompute complex aggregates—having Oracle dynamically rewrite SQL to reference precomputed aggregate information.