A simple concatination example of string column with an arbiturary string in Oracle.
Or
Which operator in oracle is used to concatinate string column with an arbiturary string.

Answer:

The purpose of this question make the user aware of the operator to be used in Oracle, which is different than MS SQL's '+' operator for the same purpose.

The example of this operator is :

select 'Student Name' || STD_NM from tblStudents

the operator '||' is used for this purpose.