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.
相关文章