Oracle SQL concatenate multiple columns and add text

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