Re: Hiding hint in SQL from SQL Trace?

From: William Robertson <william.robertson_at_bigfoot.com>
Date: 29 Sep 2005 15:47:07 -0700
Message-ID: <1128034027.348492.152610@g14g2000cwa.googlegroups.com>

enrikonewsgro..._at_earthlink.net wrote:
> I have an ETL application that allows you to select a table delivery
> method, one of which is APPEND. When I select this option and turn on
> sql trace to watch the sql being generated there is no /*+ APPEND */
> hint in the INSERT statement.
> The application is written in C/C++.
>
> Is it possible to hide a hint from sql trace?

Are you sure it is supposed to do an INSERT /*+ APPEND */?

Perhaps it just means APPEND as opposed to REPLACE, i.e. don't delete the existing data before loading? Received on Thu Sep 29 2005 - 17:47:07 CDT