when using hint, is hint case sensitive or not?
I presume that it is case sensitive.
Life is a journey, not a destination!
select /*+ full(a) */ * from a;
select /*+ FULL(a) */ * from a;
so do you mean that
the first one will ignore the hint,
and the second one will use hint?
I can not tell you that i saw it in the oracle doc, but i know that every time you are using a hint, you use capital letters. if you what to use an index hint, you write the name of the index and the table in capital letters.
Hi, 16th May 2001 13:20 hrs *******
1)Hint will have no effect if there is more than one WHERE clause.
2)no where as for as i have not seen anywhere oracle suggest not to use in lower case the using hints
[Edited by padmam on 05-19-2001 at 04:24 AM]
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
The "hint" id buried inside a comment (so follows the same rule of comments - no key sensitive). If the syntax is incorrect or the hint is inappropriate, it will be treated as a comment and ignored.
Click Here to Expand Forum to Full Width