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