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.
Asked In: Many Interviews |