String||String: concatenates two strings : String Concatenate « Char Functions « Oracle PL / SQL

1. Oracle PL / SQL
2. Char Functions
3. String Concatenate

String||String: concatenates two strings

SQL> -- String||String
SQL>
SQL> -- This function concatenates two strings.
SQL>
SQL> -- String||String
SQL> SELECT 'This' || ' is '|| 'a' || ' concatenation' FROM dual;

'THIS'||'IS'||'A'||'CON
-----------------------
This is a concatenation

SQL>

           
       

Related examples in the same category