Database & SQL

You have two options for concatenating strings in Oracle:

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

http://stackoverflow.com/questions/1619259/oracle-sql-concatenate-multiple-columns-add-text