Note: The following SQL procedure examples assume that the DBMS tables have not been updated by other examples. proc access dbms=oracle; /* create access descriptor */ create adlib.product.access; ...

PROC SQL allows you to specify the ORDER BY clause in the CREATE VIEW statement ... In the following example, a connection is made and the libref ACCREC is assigned to an ORACLE database. For more ...