Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: truncating values on insert ?
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
![]() |
![]() |