||: the concatenation operator : Concatenation Operator « PL SQL « Oracle PL / SQL

1. Oracle PL / SQL
2. PL SQL
3. Concatenation Operator

||: the concatenation operator

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>
           
       

Related examples in the same category