CONCAT multiple

Question

Can we use concat concatenate multiple fields ?

Answer 1

Yes. In oracle the || is the concat operator, the other sql lang have the CONCAT() function.