Concatenate Strings Using || Operator in Oracle SQL PLSQL

The || operator in Oracle SQL / PLSQL can be used to concatenate multiple strings to form a single string.

Syntax for the using the || operator in Oracle SQL / PLSQL is:

SELECT string_1 || string_2 || string_3 || . . . || string_N
FROM table_name;

string_1, strring_2 . . string_N are the strings to be concatenated.

Examples:

Using || operator in Oracle SQL / PLSQL SELECT statement:

SELECT 'MONDAY '|| 'TUESDAY '|| 'WEDNESDAY '
FROM dual;

Will return ‘MONDAY TUESDAY WEDNESDAY ‘

SELECT 'TECH' || 'HONEY' || '.COM'
FROM dual;

Will return ‘TECHHONEY.COM’


Tagged , , , , , , , , , , , . Bookmark the permalink.
  • I really like your blog.. very nice colors & theme. Did you make this website yourself or did you hire someone to do it for you? Plz answer back as I’m looking to create my own blog and would like to find out where u got this from. thanks

    • admin

      Hi,
      Thanks for dropping by on techhoney.com. The theme we are using is Mantra and is a free theme from WordPress.

      Thanks again
      Admin