Multiple choice technology databases

Which operator is equivalent to concat function?

  1. &

  3. ||

  4. &&
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In Oracle and PostgreSQL SQL, the || (double pipe) operator is the standard concatenation operator that joins two strings together. The CONCAT() function does the same thing. Single operators like &, |, and && are bitwise operators, not string concatenation in SQL.

Keep practicing — related questions