Data Set Options for Relational Databases |
Default value: | none |
Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
DBMS support: | Oracle |
Syntax | |
Syntax Description | |
Details | |
Examples |
Syntax |
ORHINTS='Oracle-hint' |
Details |
If you specify an Oracle hint, SAS passes the hint to Oracle. If you omit ORHINTS=, SAS does not send any hints to Oracle.
Examples |
This example runs a SAS procedure on DBMS data and SAS converts the procedure to one or more SQL queries. ORHINTS= enables you to specify an Oracle hint for SAS to pass as part of the SQL query.
libname mydblib oracle user=testuser password=testpass path='myorapath'; proc print data=mydblib.payroll(orhints='/*+ ALL_ROWS */'); run;
In the next example, SAS sends the Oracle hint '/*+ ALL_ROWS */' to Oracle as part of this statement:
SELECT /*+ ALL_ROWS */ * FROM PAYROLL
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.