Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Field scan question - PL/SQL trigger
Jim.Pickett_at_cubic.com wrote in message ...
>I have been asked to develop a trigger that will allow me to parse
>a VARCHAR2(30) field to see if it contains an asterisk or double
>quote.
There's an Oracle FUNCTION called INSTR which will look for the occurence of a character in a string. I think this will solve your problem.
Sandy Received on Thu Jan 15 1998 - 00:00:00 CST