Menu
Would it be possible to explain the difference between the concat() function and the || operator in Oracle?
Which one is better in terms of performance?
558
The Oracle/PLSQL || operator allows you to concatenate 2 or more strings together.
concat() method takes only one argument of string and concatenates it with other string. + operator takes any number of arguments and concatenates all the strings.
CONCAT can join only two things while CONCATENATE can join two or more things.
The concatenation operator is a binary operator, whose syntax is shown in the general diagram for an SQL Expression. You can use the concatenation operator ( || ) to concatenate two expressions that evaluate to character data types or to numeric data types.
There is no functional difference.
|| is the ANSI standard string concatenation operator (though, unfortunately, not every database <cough>SQL Server</cough> chooses to support the standard). Many databases support a CONCAT function so it may be easier to port code using CONCAT to different databases.
126
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
