From Oracle support website:
'Hints in PL/SQL blocks should have a SPACE after the '+' which starts
the hint comment. This is important otherwise the hint may be ignored
as some versions of PL/SQL omit the first character after the '+' sign
when passing the query to the SQL engine. Eg: Use "SELECT /*+ FULL(a)
*/" rather than "SELECT /*+FULL(a)*/"'
Two questions:
1. Are PL/SQL blocks considered those within stored procedures,
functions, and Pro*C++ code?
2. What versions of PL/SQL omit the first character after the '+' sign
in a hint when passing the query to the SQL engine?
Thank you.
Received on Tue Apr 23 2002 - 08:38:32 CDT
