Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

difference between concat and concatenation operator ||

Laurent SchneiderSep 20 2004 — edited Sep 20 2004
Hi,
Most of us may think there is no difference between CONCAT and ||

By looking in the doc, I can read
This function is equivalent to the concatenation operator (||). The function is useful when there are spaces in the values to be concatenated. The concatenation operator does not permit spaces.
<URL:SQL Reference>

I cannot find a query with a difference, can you?
SQL> select 'a '||' b',concat('a ',' b') from dual

'A'||'B' CONCAT('A','B')
-------- ---------------
a  b     a  b
Thanks for feedback
Laurent
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 18 2004
Added on Sep 20 2004
2 comments
2,618 views