Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Hints in Practice

Re: Hints in Practice

From: Bob Jones <email_at_me.not>
Date: Sat, 26 Aug 2006 02:19:11 GMT
Message-ID: <zcOHg.3193$yO7.2621@newssvr14.news.prodigy.com>


> The following is perfectly valid Oracle syntax:
>
> SELECT /*+ Bob Jones is making an argument that doesn't hold water */
> table_name
> FROM user_tables;
>
> And if you don't believe me ... copy it into SQL*Plus.

Hmmm, it didn't work until I changed it to:

SELECT /*+ DA Morgan is lost in the ocean of hints.*/ *
FROM many_stars; Received on Fri Aug 25 2006 - 21:19:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US