Home » SQL & PL/SQL » SQL & PL/SQL » Hint CHOOSE (Oracle Database 10g Enterprise Edition Release 10.2.0.3.0)
Hint CHOOSE [message #329829] Thu, 26 June 2008 12:25 Go to next message
scoolj
Messages: 2
Registered: June 2008
Location: Bangalore
Junior Member
Hi!

Some of our SQL code used on Oracle[Oracle Database 10g Enterprise Edition Release 10.2.0.3.0, Oracle Client 10.2.0], has the hint CHOOSE. I understand the hint CHOOSE is desupported in Oracle 10. Is there any impact on having it in the SQL or is it just ignored? It clearly does not cause an error but I didn't know if had any other effect.

Thanks.

Br,
Sri
Re: Hint CHOOSE [message #329838 is a reply to message #329829] Thu, 26 June 2008 12:47 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Every invalid hint is treated as comment. If it really is desupported, then this will be treated as an invalid hint, hence a comment.
No problem, except that it will confuse future developers, like it did you.

[Updated on: Thu, 26 June 2008 12:48]

Report message to a moderator

icon7.gif  Re: Hint CHOOSE [message #329844 is a reply to message #329838] Thu, 26 June 2008 13:15 Go to previous message
scoolj
Messages: 2
Registered: June 2008
Location: Bangalore
Junior Member

Thanks Frank.
Previous Topic: how to use custom datatype in SQL ???
Next Topic: Connect Oracle 8i server to Oracle 10g server
Goto Forum:
  


Current Time: Tue Dec 06 00:19:22 CST 2016

Total time taken to generate the page: 0.12343 seconds