Oracle – Concatenating More Than Two Columns

I didn’t realize you couldn’t pass an arbitrary number of parameters to CONCAT in Oracle — you’ve got to chain your concatenations:

CONCAT(NL.CLLI_CODE, CONCAT('-',C.CIRCUIT_ID)) as TabName

To produce ABCDOH-12345

Leave a Reply

Your email address will not be published. Required fields are marked *