if ( (LENGTH(TRIM(TRANSLATE(contentcode, ‘+0123456789′,’ ‘))) is not null) or (LENGTH(TRIM(TRANSLATE(otherfield, ‘+0123456789′,’ ‘))) is not null)) then
dbms_output.put_line(‘contentcode or otherfield is invalid’);
eaziweb is a simple blog where a web developer/computer professional will find the solution for his day to day problem.
Showing posts with label isnumber. Show all posts
Showing posts with label isnumber. Show all posts
Monday, June 11, 2012
oracle procedure : number validation
Subscribe to:
Posts (Atom)