| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Hint in a cursor ????
Hi,
I think you are referring to "c" as in pro*c. I think you could rewrite the cursor in pro*c as ,
cursor cust_curs_club
SELECT --+HINT SHOULD GO HERE
to_char(cus.date_of_birth,'YYYYMM')...
....
Make sure that you notice the line break after the hint and before the to_char... stuff. "--+" is other way of specifying the hint.
Hope this helps.
Viral Desai.
>From: Robertson Lee - lerobe <lerobe_at_acxiom.co.uk>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Hint in a cursor ????
>Date: Fri, 13 Sep 2002 09:03:20 -0800
>
>All,
>
>Tru64
>Oracle 8.0.5
>
>One of our developers is trying to put a hint into a cursor (see below)
>
>cursor cust_curs_club HINT SHOULD GO HERE to_char(cus.date_of_birth,
>'YYYYMM')
>
>He is saying that the c is picking up the hint statement as a comment ( /*)
>
>Anyone know how to fix this. This out of my area.
>
>Regards
>
>Lee
>
>
>*********************************************************************
>
>The information contained in this communication is
>confidential, is intended only for the use of the recipient
>named above, and may be legally privileged.
>If the reader of this message is not the intended
>recipient, you are hereby notified that any dissemination,
>distribution, or copying of this communication is strictly
>prohibited.
>If you have received this communication in error,
>please re-send this communication to the sender and
>delete the original message or any copy of it from your
>computer system. Thank You.
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Robertson Lee - lerobe
> INET: lerobe_at_acxiom.co.uk
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viral Desai INET: viral303_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Fri Sep 13 2002 - 15:29:33 CDT
 |
 |