Get Started with Redwood for Oracle Cloud HCM Begin Now
What are the equivalents of CONTINUE and NULL in Fast Formulas compared to PL/SQL?
I'm looking for a way to bypass the current iteration of a loop and move on to the next one, similar to how CONTINUE
works in other languages. Please suggest an equivalent solution?
Additionally, I'd like to know if there's a placeholder or a value that I can use to indicate an empty or null condition in an if
statement, similar to how null
is used in other languages.
Sample code below-
Continue: WHILE (nidx < tcRecCount ) LOOP ( if isnull(l_absence) = 'N' then/*If l_absence is null*/
(
CONTINUE /*Continue to next iteration- I need keyword here*/
) ) NULL: if isnull(l_absence) = 'N' then/*If l_absence is null*/
0