Snippet Name: Function For Number Handling Description: This 'AndNotNum' Function is intended to check a string or number to see if it contains one nested element but does not contain a second nested element. Also see:» FUNCTIONS: Deterministic » FUNCTIONS: Nested Functions » FUNCTIONS: IF statement » FUNCTIONS: date/time » FUNCTIONS: Sample functions » FUNCTIONS: drop » FUNCTIONS: Recompile » FUNCTIONS: DEBUG mode » FUNCTIONS: IN OUT parameter » FUNCTIONS: with output parameters » FUNCTIONS: with parameters » FUNCTIONS: without parameters » FUNCTIONS: Create function » FUNCTIONS: special restrictions » FUNCTIONS: System Privileges » IN Function » Built-In Functions: CASE » Built-In Functions: DECODE » SUBST and INSTR together » INSTR (InString) » SUBSTR (SubString) » String Functions: REVERSE » String Functions: LENGTH » String Functions: INSTR » String Functions: CONCAT » String Functions: CHAR » String Functions: INITCAP » String Functions: LOWER » String Functions: UPPER » Date Functions: NUMTOYMINTERVAL Comment: (none) Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 01st, 2009
Description: This 'AndNotNum' Function is intended to check a string or number to see if it contains one nested element but does not contain a second nested element.
Also see:» FUNCTIONS: Deterministic » FUNCTIONS: Nested Functions » FUNCTIONS: IF statement » FUNCTIONS: date/time » FUNCTIONS: Sample functions » FUNCTIONS: drop » FUNCTIONS: Recompile » FUNCTIONS: DEBUG mode » FUNCTIONS: IN OUT parameter » FUNCTIONS: with output parameters » FUNCTIONS: with parameters » FUNCTIONS: without parameters » FUNCTIONS: Create function » FUNCTIONS: special restrictions » FUNCTIONS: System Privileges » IN Function » Built-In Functions: CASE » Built-In Functions: DECODE » SUBST and INSTR together » INSTR (InString) » SUBSTR (SubString) » String Functions: REVERSE » String Functions: LENGTH » String Functions: INSTR » String Functions: CONCAT » String Functions: CHAR » String Functions: INITCAP » String Functions: LOWER » String Functions: UPPER » Date Functions: NUMTOYMINTERVAL
CREATE OR REPLACE FUNCTION AndNotNum ( evalnum NUMBER, num1in NUMBER, num2in NUMBER) RETURN NUMBER IS evalstr VARCHAR2(38); num1str VARCHAR2(38); num2str VARCHAR2(38); NoGood EXCEPTION; BEGIN evalstr := TO_CHAR(evalnum); num1str := TO_CHAR(num1in); num2str := TO_CHAR(num2in); IF INSTR(evalstr, num1str, 1, 1) = 0 THEN RAISE NoGood; END IF; IF INSTR(evalstr, num2str, 1, 1) > 0 THEN RAISE NoGood; END IF; RETURN 1; EXCEPTION WHEN NoGood THEN RETURN 0; END AndNotNum; /
