Re: How to escape hints in PL/SQL

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Tue, 29 Aug 2006 22:54:28 +0100
Message-ID: <trd9f25mtufkuvp55a7t1sccq762v8rv4q@4ax.com>

On 29 Aug 2006 14:25:09 -0700, "sidey" <sideyt_at_hotmail.com> wrote:

>How do you translate
>
>update (
> select/*+bypass_ujvc */ t1.c c <=====
>
>to PL/SQL?
>
> Oracle developer doesn't like the hints once you quote this line:
>
>sql_stmt := 'update(' ||
> 'select/*+bypass_ujvc */ t1.c c' ||
>
> ....... and so on...

In what way does it "not like it"?

-- 
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

Received on Tue Aug 29 2006 - 16:54:28 CDT