SELECT 'Hello' || ' ' || 'World' || CASE WHEN '1'='1' THEN '_YES' ELSE '_NO' END HELLO FROM DUAL;
||是连接符号
执行结果：HELLO
Hello World_YES
