Oracle中的字符串串联运算符是什么? [英] What is the string concatenation operator in Oracle?

问题描述

Oracle SQL中的字符串连接运算符是什么?

What is the string concatenation operator in Oracle SQL?

有没有我应该注意的有趣"功能?

Are there any "interesting" features I should be careful of?

(这似乎很明显，但是我找不到以前的问题在问它).

(This seems obvious, but I couldn't find a previous question asking it).

推荐答案

它是||，例如:

select 'Mr ' || ename from emp;

我能想到的唯一有趣"功能是'x' || null返回'x'，而不是您可能期望的null.

The only "interesting" feature I can think of is that 'x' || null returns 'x', not null as you might perhaps expect.

这篇关于Oracle中的字符串串联运算符是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！