Concatenate a parameter with a SQL?

[AlexTardif]

Hi,

I just wanna know if it is possible include a parameter or variable to a query.

The code below is not functional (and not useful at all... lol), it's just to give you the general idea behind my question.

CREATE OR REPLACE FUNCTION Func_Test(P_STRING as VARCHAR2)
RETURN INTEGER
As
V_Cnt INTEGER
BEGIN
    SELECT COUNT(*) INTO V_Cnt
    FROM MyTable
    WHERE MyColumn LIKE ' || P_STRING || ';

END;

Thanks!

Alex

 

[carp]

Alex -
Yes, and you almost have it:

CREATE OR REPLACE FUNCTION Func_Test(P_STRING as VARCHAR2)
RETURN INTEGER
As
V_Cnt INTEGER;
BEGIN
    SELECT COUNT(*) INTO V_Cnt
    FROM MyTable
    WHERE MyColumn LIKE '%' || P_STRING || '%';
    RETURN v_cnt;
END;