Re: Help needed. How to validate date in PL/SQL(Oracle Web Server)
From: anthony simon <anthony.simon_at_univ-rennes1.fr>
Date: Wed, 29 Apr 1998 09:25:51 +0000
Message-ID: <3546E40F.63D7_at_univ-rennes1.fr>
Date: Wed, 29 Apr 1998 09:25:51 +0000
Message-ID: <3546E40F.63D7_at_univ-rennes1.fr>
> > I have an other problem
> > Is there any fuction in Pl/Sql to validate enterd
> > field is numeric.? Because I have amount field is varchar2(10).
> >
> > Please advice me.(This is bit urgent)
> > Thanks,in advance.
use the translate function
ex :
test := upper(field);
test := translate(test,'ABCD...Z','****...*')
if test = upper(field) then
- champ is numeric else
- champ is not only numeric end if
hope this will help
anthony Received on Wed Apr 29 1998 - 11:25:51 CEST