Hello,
I have this piece of code in the after header process. The problem is the value by select may contains single quote, wonder how to handle it? I mean P14_STUDY_SITE_NAME may contains single quote, how to escape it correctly? Thanks very much!
begin
select :P14_STUDY_SITE_NAME|| ' - '|| :P14_STUDY_SITE_NUM into :P14_STUDY_SITE_INFO from dual;
end;