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
string_1, strring_2 . . string_N are the strings to be concatenated.
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’
Ugg Highkoo Boots says
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
Thanks for dropping by on techhoney.com. The theme we are using is Mantra and is a free theme from WordPress.