In standard SQL, the double vertical bar || is the operator used to concatenate two or more strings together. The +, -, and * symbols are arithmetic operators used for addition, subtraction, and multiplication, respectively, and cannot be used for string concatenation.