This content has been marked as final. Show 5 replies
You could put something like this in the WHERE-clause (assuming that :BLOCK.QUERYDATA contains your value AB1;AB2;AB3;AB4; )
Maybe you have to additionally eliminate space in :BLOCK.QUERYDATA
INSTR (';' || PK_COLUMN || ';', ';' || :BLOCK.QUERYDATA || ';')>0
Its not working. Can you explain in detail please?
Its not working.Sorry, i don't have my crystal ball with me. You will have to provide information about what "It's not working" means. Do you get any error? Doesn't it retrieve data? Wrong data?
You might also test this in sql*plus.
I put that in the where condition of the block. That didnt do anything. What should it do? Should I write some code in a button?
You could try the resulting query in SQL*Plus. It should return result there. As i said, maybe you have to eliminate spaces between the pk-values and the afterwards following simicolons.