Re: empth_clob() for CLOB column in INSERT necessary ?

userjohn wrote:
> 10gR2 EE (10.2.0.3.0)
>
> Have a table with a CLOB column.
>
> In my application,
> I first INSERT and populate all OTHER columns with an INSERT
> INTO....SELECT...
>
> Later in the process I update the CLOB column like:
>
> UPDATE t_table_with_xml
> SET xml_clob = (SELECT .... FROM ....)
> WHERE t_pk = :pk
>
>
> I'm wondering, should I populate the CLOB column with empth_clob() in the
> INSERT...SELECT ?
> Does it make any difference like more efficient ?
>
> thanks

Try it.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org