Oracle Database Query With Multiple String Parameters
Need to find Oracle database records matching multiple strings in fields. Use JDBC, split param by spaces & filter records with superset match.
A table in an Oracle database has multiple string fields. Now we need to input a parameter that contains multiple strings separated by spaces. We need to find the records in the table that contain all these strings in the fields, or those records where the set of fields is a superset of the parameter. For example, when the parameter argA="street John Doe", the calculation result is as follows: SPL code: A1: Query the database through JDBC. A2: Split the parameter into a string set by spaces. Open source SPL source address Free Download A3: Filter out records where the difference between the...