Re: Insert > 2499

From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Fri, 23 Jul 2010 05:34:23 -0700 (PDT)
Message-ID: <e658e318-159f-4d81-9656-ec9faa1ab8af_at_c10g2000yqi.googlegroups.com>

On Jul 21, 8:02 pm, joel garry <joel-ga..._at_home.com> wrote:
> On Jul 21, 2:23 pm, The Magnet <a..._at_unsu.com> wrote:
>
> > I have some insert statements with values that are > 2500 characters.
> > I cannot make it a .CSV because the text has commas in it.  It is a
> > bunch of HTML.  Any suggestions?
>
> > Example:
>
> > INSERT INTO MESSAGES (message_id, sec_id, variables, name, body,
> > created, last_changed, created_by, changed_by, status) VALUES(5,
> ...
> > 'fabre', 'ONLINE');
>
> http://asktom.oracle.com/pls/apex/ASKTOM.download_file?p_file=6551245...http://www.oracle.com/technology/sample_code/tech/java/codesnippet/xm...http://stackoverflow.com/questions/2976154/how-to-store-unlimited-cha...
>
> And so on.  I'm sure I've seen some other things specific to storing
> html, those are just from a quick google.
>
> jg
> --
> _at_home.com is bogus.
> Interesting truncation in url different than meaning of post:http://blogs.oracle.com/otn/2010/06/finding_it_difficult_to_keep_u.html

I will just add if the data has commas in it then use a different delimiter such as the tab character or the pipe character.

HTH -- Mark D Powell -- Received on Fri Jul 23 2010 - 07:34:23 CDT