I am very experienced on SQL Server, but am very new to Oracle.
I had a package with a function that returned one row. However, there were rare occasions when it would need to return more than one row, so I have updated the function to return multiple rows as needed.
However, this has now caused the query that used my function to fail, because it was matching on the one returned row and now there are sometimes multiple returned rows. So, my question is, is it possible to update the following case statement to look through a subset instead? If so, what would the syntax be?
Something like: CASE WHEN Field4 IN package.function(Field3) THEN...
SELECT Field1, Field2, (CASE WHEN package.function(Field3) = Field4 THEN 'True' ELSE 'False' END)