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: constraints

Re: constraints

From: Anders Karbæk <akarb_at_xinfo.dk>
Date: 2000/08/06
Message-ID: <20000806.15044458@mis.configured.host>#1/1

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

Original text of this message

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