Oracle SQL, concatenate multiple columns + add text
You have two options for concatenating strings in Oracle: CONCAT Using || CONCAT example: CONCAT( CONCAT( CONCAT( CONCAT( CONCAT(‘I like ‘, t.type_desc_column), ‘ cake with ‘), t.icing_desc_column), ‘ and a ‘), t.fruit_desc_column) Using || example: ‘I like ‘ || t.type_desc_column || ‘ cake with ‘ || t.icing_desc_column || ‘ and a ‘ || t.fruit_desc_column