SQL>
SQL> -- Use of the concatenation operator.
SQL> SET SERVEROUTPUT ON
SQL> DECLARE
2 a VARCHAR2(30);
3 b VARCHAR2(30);
4 c VARCHAR2(30);
5 BEGIN
6 -- Concatenate several string constants.
7 c := "A" || " AND " || "B";
8 DBMS_OUTPUT.PUT_LINE(c);
9 -- Concatenate both string variables and constants.
10 a := "A";
11 b := "B";
12 DBMS_OUTPUT.PUT_LINE(a || " " || b || ",");
13 -- Concatenate two string variables.
14 a := "A ";
15 b := "B";
16 c := a || b;
17 DBMS_OUTPUT.PUT_LINE(c);
18 END;
19 /
A AND B
A B,
A B
PL/SQL procedure successfully completed.
SQL>
