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’);
Showing posts with label dbms_output.put_line. Show all posts
Showing posts with label dbms_output.put_line. Show all posts
Monday, June 11, 2012
oracle procedure : number validation
Subscribe to:
Posts (Atom)