create view proclib.view1 as select * from accrec.invoices as invoices using libname accrec oracle user=username pass=password path='dbms-path'; For more information on the SAS/ACCESS LIBNAME ...

The Microsoft Access database engine does not support the use of CREATE VIEW, or any of the DDL statements, with non-Microsoft Access database engine databases. The SELECT statement that defines the ...

Creating views:views are virtual tables which are created from other tables .it is beneficial for those situation when we want to show limited columns to users. it can be created from one or more ...