Re: errr, umm, variables in inserts, possible, help? :)

On 3 Feb 2002 13:24:32 -0800, Thomas Kyte <tkyte_at_us.oracle.com> wrote:

>Just add:
>
>set define off
>
>at the top of your script, also add:
>
>alter session set cursor_sharing=force;
>
>and it'll run faster/smoother and won't kill your shared pool.
>

It's easy when you know how :)

Cheers Thomas, that would have taken me days of trawling through the docs to find.

Cheers
Mike Williams
notnet Webhosting
http://www.notnet.co.uk Received on Sun Feb 03 2002 - 16:31:22 CST