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

 Posted by Puneet20884 on 10/18/2010 | Category: Others Interview questions | Views: 2525 | Points: 40

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 | Alert Moderator 

Comments or Responses

Login to post response