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

Home -> Community -> Usenet -> c.d.o.tools -> Re: how to insert string " Version 3.4.5 " into oracle as varchar2? Decimal causes problems

Re: how to insert string " Version 3.4.5 " into oracle as varchar2? Decimal causes problems

From: <martin_suttrup_at_my-deja.com>
Date: Mon, 11 Dec 2000 07:06:01 GMT
Message-ID: <911uco$mr1$1@nnrp1.deja.com> 






In article <qj383tckh68bh65vq4b2vvj7ks2oblk2ui_at_4ax.com>,
  kilidire <cr389_at_torfree.net> wrote:


> Does anyone know how to insert that data into a table as a varchar2 ?

> Thanks.

> The decimal is causing some problems ...

>



Hi,


I didn't know what the problem should be. Test it:
create table test(v1 varchar2(255));


insert into test values('Version 3.4.5');



May be you should not use double quotes (") to enclose strings.



Martin




Sent via Deja.com http://www.deja.com/


Before you buy.
Received on Mon Dec 11 2000 - 01:06:01 CST












Original text of this message













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