Forum .LRN Q&A: ORACLE FUNCTION TYPICAL

Collapse
Posted by Ashish Surkar on
i am building a function from which i can find out the next approval in the string of user.
For example i A,B,C are three users. and in string it is set that first A or B i.e (A||B) can approved after that C can approved.like that the senerio as as follows.
There will be two input string in function first one is rule((A||B)&&C) and second one is approval(A) just check the below senerio.
The rule is
Senerio I : String (A||B)&&C
so if A is the input then output should be C.
if B is the input then output should be C.
if C is the input then output should be A||B

Senerio II : String (A&&B)||C
if input is A the output will be B||C
if input is B the output will be A||C
if input is C the output will be (A&&B)