Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP PLEASE! (A real newbie)
Peter Giannopoulos <petergi_at_generation.net> wrote:
>I need to get SQLLOader to stuff lots of text into some field. I don't
>know what datatype to use. Varchar2 just can't handle the (varying)
>amouny of text.
>
>Can anyone help me?
>
>Thanks in advance.
>
>--
>-----------------------------------------------------------------------
>"Do not look to authority for truth - look to truth for authority."
>Yoshida Kenji Sensei - Yanagi Ryu Aiki Bugei
>
>Peter Giannopoulos
>generation.net
>Database & Web Applications Developer
>
>Ph: 514-845-5555 ext.218
>Fax: 514-845-5004
>ICQ# 1723017
>------------------------------------------------------------------------
If your text is less than 2000 characters in length, and doesn't
contain quites ", then use the quotes " to delimit the text. This
should solve the problem for you.
I hope this helps,
David
David Greensmith :-)
(david_at_green1.demon.co.uk)
Received on Sat Aug 08 1998 - 22:47:15 CDT