Oracle SQL Hints are used to pass instructions, or hints, to the performance optimizer of SQL statement.
Syntax:
SELECT /*+ <orahint> */ ... UPDATE /*+ <orahint> */ ... DELETE /*+ <orahint> */ ... INSERT /*+ <orahint> */ ...
In ESL script actions, the value is used without the opening and terminating characters /*+, */.
Example of use:
;with APPEND the rows are written directly to the datafiles and are not logged DBS_INSERT DB.AR_USER_PRAVO_TEMP, _Temp, _retCode ORAHINT "append" IF _retCode # _ERR_NO_ERROR THEN CALL [E.AR] LogError((%GetLastExtErrorCode())) ASYNC ON AR.EVH ENDIF |
You can find more information in Oracle documentation.