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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Auto-Truncate into VARCHAR

Re: Auto-Truncate into VARCHAR

From: Neil Hulin <nospam_at_litech.freeserve.co.uk>
Date: Wed, 11 Nov 1998 13:55:28 -0000
Message-ID: <72c51r$h1r$1@newsreader1.core.theplanet.net> 





Try using the substr() function in the insert statement. e.g. insert into
MYTABLE values (substr(myvar,1,20));



...neil [Actually: neil.hulin_at_litech.freeserve.co.uk]


Received on Wed Nov 11 1998 - 07:55:28 CST












Original text of this message













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