Oracle again...

INTRODUCTION TO ORACLE:

String concatenation || can be use in the SELECT clause


SELECT area_code || '-' || phone_number
FROM address;

will concatenate the area code 518 and phone number 2766666 and produce a result like 518-2766666.