String Operators : Operators « PL SQL Operators « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. PL SQL Operators
3. Operators

PL/SQL has two operators specifically designed to operate only on character string data.

These are the LIKE operator and the concatenation (||) operator.

The Syntax for the Concatenation Operator:

string_1 || string_2

string_1 and string_2 are both character strings and can be string constants, string variables, or string expressions.

SQL>
SQL> SET SERVEROUTPUT ON
SQL>
SQL> DECLARE
  2    a     VARCHAR2(30);
  3    b     VARCHAR2(30);
  4    c     VARCHAR2(30);
  5  BEGIN
  6    c := 'A' || ' AND ' || 'B';
  7    DBMS_OUTPUT.PUT_LINE(c);
  8     a := ' C ';
  9     b := ' D ';
 10     DBMS_OUTPUT.PUT_LINE(a || ' ' || b || ',');
 11     a := ' E ';
 12     b := ' F';
 13     c := a || b;
 14     DBMS_OUTPUT.PUT_LINE(c);
 15  END;
 16  /
A AND B
C   D ,
E  F

PL/SQL procedure successfully completed.

SQL>