Using the LIKE command in an Oracle function (PL/SQL)
Does anyone know what the Oracle function syntax would be for the following pseudo code:
LIKE %(UPPER(VariableName))%
where VariableName is an input variable? I am trying to do both an UPPER and a LIKE command at once. I think it should look something like this:
LIKE ''% ' || UPPER('''||ElementName||''') || ' %''
but I just can't seem to get the quotes right in the function. It works as the following straight SQL query (but not as a function):
LIKE '%' || UPPER('Primary User') || '%'
Or, if anyone knows where the rules for quotes in Oracle functions are written, that would help too.
Thanks!