Relative Content

Tag Archive for stringoracleplsqlstring-comparisonsql-function

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).