String Concatenation - SQL Query(pl-sql function body returning SQL query
Hello all,
I just have problem with concatenation of the string . I would like to return something like " Lname , FNAMe " but the below returns Lnamefname
v_sql := ' SELECT concat(LNAME,FNAME) as CONTRACTOR,'
||' s.TEAM as TEAM,'
||' s.CONTRACT_NO as CONTRACT_NO,'
||' FROM s '
I also tried the below which gave the results as fname (seprate column as contractor ) and lname was given seprately as lname... I would like to have it like
example result should be something like := Weigner , Lucy
v_sql := ' SELECT LNAME'|| ', ' ||'FNAME CONTRACTOR,'
||' S.TEAM as TEAM,'
||' S.CONTRACT_NO as CONTRACT_NO,'
Thank you