String Concatenation

Источник: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:2196162600402

<code>Hi Tom, Is there anyway that I can just use SQL to do string concatenation on a VARCHAR2 field much the same way that a SUM() function is used on a NUMBER field. For example, SELECT SUM(revenue), department FROM sales_table ...