Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Command - Insert string within the quotation mark limits to 2000 charater

Re: SQL Command - Insert string within the quotation mark limits to 2000 charater

From: TurkBear <noone_at_nowhere.com>
Date: Mon, 24 Sep 2001 12:55:11 -0500
Message-ID: <2psuqt4l0pgj0l5aro5o52bnme877i8sas@4ax.com>

What version -
 how is the field defined -
 why not a separate insert for all the 'short' values and an update for the longer ones? btw,
In 8i varchar2 can be 4000 chars...

"Ricky W.K.Lo" <lowk_at_mindware.com.hk> wrote:

>As the tile.
>
>Who knows how to overcome this problems --->
>
>Insert into TABLE (Field1, Field2........) (Value 'Charaters more than
>2000');
>
>Tks/B.Rgds, Ricky
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!  Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Mon Sep 24 2001 - 12:55:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US