Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is There A Native OCCURS() Function
Message
General information
Forum:
Oracle
Category:
PL/SQL
Miscellaneous
Thread ID:
00898953
Message ID:
00900464
Views:
17
This message has been marked as the solution to the initial question of the thread.
No, but it is easy to create one:
  FUNCTION OCCURS(in_String  IN VARCHAR2,
                  in_LookUp  IN VARCHAR2)
        RETURN PLS_INTEGER IS
   i PLS_INTEGER;
   l_RetVal PLS_INTEGER := 0;
  BEGIN
   FOR i IN 1..9999 LOOP
     IF INSTR(in_String, in_LookUp, 1, i) > 0 THEN
        l_RetVal := l_RetVal + 1;
     ELSE
        EXIT;
     END IF;
   END LOOP;
   RETURN l_RetVal;
  END OCCURS;
>Hi All,
>
>Does anyone know if there is a native function in Oracle 8 that works like the VFP OCCURS() function?
>
>
>Thanks,
>
>- Brian
George
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform