And in PL/SQL you need to keep the space after the '+'
hth
connor
- Viral Desai <viral303_at_hotmail.com> wrote: > 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).
>
>
>
>
>
> Chat with friends online, try MSN Messenger:
> http://messenger.msn.com
>
> --
> 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).
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net
"Remember amateurs built the ark - Professionals built the Titanic"
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.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).
Received on Sat Sep 14 2002 - 14:43:20 CDT