Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

apex pl sql function body returning query - with 'like' in select

tomita.serbanDec 13 2021

Hello
I need to build a function that returns a select with the where like clause.
P27_Tags returns %bar%
I tried:
declare
vsql varchar2 (4000);
begin
vsql: = 'select part.denumire as d, part.id_part as v from parteneri part where part.tag like' || : P27_Tags;
return vsql;
end;

.... But it does not work

Comments
Post Details
Added on Dec 13 2021
8 comments
6,576 views