I work in Oracle SQL a good bit and for a while I've known how to concatenate values. You use 2 consecutive vertical bar characters: I've been concating returned values to quickly create new queries ...

/* When you are writing a program with dynamic SQL in it (that is, you construct your statement at runtime and execute it with EXECUTE IMMEDIATE or DBMS_SQL - most likely and preferably the former), ...