I am trying to get the value from the itnum field which is TEST1234. (Need inside the two single quote)

filter=‘(itnum = ‘’TEST1234’’) AND (dbnum like ‘’Y%’’)’

Tried something like this but unable to get

select nvl(substr(@filter, 15, instr(@filter, ‘=‘) -1), @filter) AS output from dual

Can someone help me to achieve?