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: truncating values on insert ?

Re: truncating values on insert ?

From: Bricklen Anderson <bricklen13_at_hotmail.com>
Date: 15 Feb 2002 09:55:14 -0800
Message-ID: <b416ca2d.0202150955.3af456d3@posting.google.com>


I just realized that I forgot to finish that trigger I was building for you...
Oops
anyways, it was just a part about (once the row length is determined to be greater than 10 or whatever your value is): do the insert statement with the substr command.

"news.netcologne.de" <joerg.jung_at_clarity-ag.net> wrote in message news:<a4iuc5$h6h$1_at_news.netcologne.de>...
> hi,
>
> is there a way to force oracle to truncate too large values automatically on
> an per insert base ?
>
> thanx for help, jj
Received on Fri Feb 15 2002 - 11:55:14 CST

Original text of this message

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