PL/SQL function to detect a one way character change between 2 strings
I want to write a PL/SQL function with 4 arguments: SEARCH_STRING
, CHECK_STRING
, SEARCH_CHAR
and CHECK_CHAR
where the function will check the SEARCH_STRING
against the CHECK_STRING
and detect whether the only difference between the 2 strings is that some CHECK_CHAR
in CHECK_STRING
got changed to SEARCH_CHAR
(and everything other than that is the same).