ORHINTS=

ORHINTS=

Specifies ORACLE hints to pass to ORACLE from a SAS statement or SQL procedure.

Default value: None

Syntax
Details
Example: Passing an ORACLE Hint in a SAS PROC step

Syntax

ORHINTS ='ORACLE-hint'

ORACLE-hint: specifies an 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.

ORHINTS= can also be specified with the HINTS= alias.

Example: Passing an ORACLE Hint in a SAS PROC step

When you run a SAS procedure on DBMS data, SAS converts the procedure to one or more SQL queries. The ORHINTS= data set option enables you to specify an ORACLE hint for SAS to pass as part of the SQL query.

libname mydblib oracle user=scott password=tiger 
   path='myorapath';

proc print data=mydblib.payroll(orhints=
'/*+ ALL_ROWS */');
run;

In this example, SAS sends the ORACLE hint

'/*+ ALL_ROWS
*/'

to ORACLE as part of the following statement:

SELECT /*+ ALL_ROWS */ * FROM PAYROLL

Chapter Contents
Previous
Next
Top of Page