Hi Community Folks,
We are writing PL/SQL query in a page to get the value for the field in column list from Search value box thru dynamic query, when trying to give column value as it is working fine, but making it as dyanamic query it is throwing error. All necessary documents attached. Kindly help.
--where customer_name like ''%' || upper(:P7_SEARCH_VALUE) || '%''' ;
--where ' || ' :P7_COLUMN_LIST ' || ' like ''%' || upper(:P7_SEARCH_VALUE) || '%''' ;
error_query.txt (3.53 KB)
