Oracle SQL concatenate multiple columns and add text April 22, 2021 You have two options for concatenating strings and column values in Oracle: CONCAT Using || CONCAT example: select CONCAT(ROW_ID,'text') from s_contact; Using || example: select ROW_ID || 'text' from s_contact; Source: StackOverflow Read more
