I am using dynamic SQL in my Procedure that has one parameter named
Dep_ID varchar(50).
Inside procedure, I need one dynamic SQL to fulfill the same function
like:
select first_name || ','||last_name from employee where dep_id in
(Dep_id)
How to express || in dynamic sql? Or can I use concat function and how
to use it in dynamic sql ? I got error by using CONCAT(p1,p2).
Thanks a million for any help!