"| |" in Oracle statement What does it mean?

"| |" in Oracle statement What does it mean?

"| |" in Oracle statement What does it mean? is the connector "+" with the string in Serversql a concept?

1. Well yes is a meaning ... Select ' 1 ' | | ' 2 ' from dual rep 12

2. The connector "+" with the string in Serversql is a concept

3.

--连接字段 SQL>  select ‘ABC‘ || ‘EFG‘ from dual; ‘ABC‘ || ‘EFG‘ ------------ ABCEFG 也可以使用concat()函数 select concat( ‘A‘ , ‘B‘ )  from dual;4. Yes, it is the same as the Java + number. Equivalent to series 5. ' | | ' Used to stitch associative fields in Oracle 6. The connection string, equivalent to + in SQL Server, can also be connected using the concat () function 7. Connector for columns and columns, columns and arithmetic expressions, or columns and constants create a character expression
Like what
Sql>select ename| | ' is a ' | | Job as "Employee Details" from EMP;
The query results are:
Employee Details
-------------------------
SMITH is a clerk
ALLEN is a salesman
WARD is a MANAGER

"| |" in Oracle statement What does it mean?