我写的存储过程,需要,组合sql语句
SQL_STR VARCHAR2(512) := 'SELECT aa FROM TF_SHUKKA ';SQL_STR_WHERE := 'WHERE aa.okline LIKE % ' || p_i_KENSAKUGO || '% ';
SQL_STR =SQL_STR || SQL_STR_WHERE
但是 生成的sql语句 为
SELECT aa FROM TF_SHUKKA WHERE TF_SHUKKA .okline LIKE % p_i_KENSAKUGO %我要怎么写才能变成 SELECT aa FROM TF_SHUKKA WHERE TF_SHUKKA .okline LIKE '% p_i_KENSAKUGO %'
呢,谢谢大家帮助
SQL_STR VARCHAR2(512) := 'SELECT aa FROM TF_SHUKKA ';SQL_STR_WHERE := 'WHERE aa.okline LIKE % ' || p_i_KENSAKUGO || '% ';
SQL_STR =SQL_STR || SQL_STR_WHERE
但是 生成的sql语句 为
SELECT aa FROM TF_SHUKKA WHERE TF_SHUKKA .okline LIKE % p_i_KENSAKUGO %我要怎么写才能变成 SELECT aa FROM TF_SHUKKA WHERE TF_SHUKKA .okline LIKE '% p_i_KENSAKUGO %'
呢,谢谢大家帮助
SQL_STR_WHERE := 'WHERE aa.okline LIKE ''% ' || p_i_KENSAKUGO || '%'' ';
SQL_STR =SQL_STR || SQL_STR_WHERE