Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: constraints
Make a function (in oracle) testing wether the string is a number, and
create/call this function from a trigger. akarb_at_xinfo.dk
>>>>>>>>>>>>>>>>>> Oprindelig meddelelse <<<<<<<<<<<<<<<<<<
Den 04-08-00, 23:21:46, skrev Jan Dinger <gateway_at_oor2.de> til emnet
constraints:
> Hallo !
> I 've got an external application, which sends strings (numbers (6)) i
nto
the database, 8i.
> The row ist varchar (7).
> The client-application behind the database only allow integer strings.
> But sometimes it happens that the input contains letters.
> How can I make a constraint, who filters the output from the external
application, to avoid an input of letters ?
> Tsch , Jan!
Received on Sun Aug 06 2000 - 00:00:00 CDT