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

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 18 2004

Added on Sep 20 2004

2 comments

2,625 views