• Skip to primary navigation
  • Skip to main content

Tech Honey

The #1 Website for Oracle PL/SQL, OA Framework and HTML

  • Home
  • HTML
    • Tags in HTML
    • HTML Attributes
  • OA Framework
    • Item in OAF
    • Regions in OAF
    • General OAF Topics
  • Oracle
    • statement
    • function
    • clause
    • plsql
    • sql
You are here: Home / Oracle / sql / Concatenate Strings Using || Operator in Oracle SQL PLSQL

Concatenate Strings Using || Operator in Oracle SQL PLSQL

November 23, 2012 by techhoneyadmin

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’


Filed Under: sql Tagged With: CONCAT || Operator in oracle plsql, CONCAT || Operator in oracle sql, CONCATWITHPLSQL, how to use CONCAT || Operator in oracle database query, how to use CONCAT || Operator in oracle plsql, how to use CONCAT || Operator in oracle sql, syntax and example of CONCAT || Operator in oracle database query, syntax and example of CONCAT || Operator in oracle plsql, syntax and example of CONCAT || Operator in oracle sql, using CONCAT || Operator in oracle database query, using CONCAT || Operator in oracle plsql, using CONCAT || Operator in oracle sql

Reader Interactions

Comments

  1. Ugg Highkoo Boots says

    November 26, 2012 at 1:43 am

    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 says

      November 26, 2012 at 7:08 pm

      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

Copyright © 2023 · Parallax Pro on Genesis Framework · WordPress · Log in