In SQL Plus concatenation of strings can be achieved with the concatenation operator ||. Example 5.6.11 In the next select phrase we concatenate the string ’Student ’ with a student’s name, then with the string ’ lives in ’ and the student’s state:
In SQL Plus concatenation of strings can be achieved with the concatenationoperator ||.Example 5.6.11 In the next select phrase we concatenate the string ’Student’ with a student’s name, then with the string ’ lives in ’ and the student’s state: