CONCAT函数与“||”符号的功能类似,就是将两个字符串联起来。
sec@ora10g> select concat(FIRST_NAME,FAMILY_NAME) “My Name is” from t;
My Name is
Secooler HOU
使用“||”可以实现同样的效果
sec@ora10g> select FIRST_NAME||FAMILY_NAME “My Name is” from t;
My Name is
Secooler HOU
CONCAT函数与“||”符号的功能类似,就是将两个字符串联起来。
sec@ora10g> select concat(FIRST_NAME,FAMILY_NAME) “My Name is” from t;
My Name is
Secooler HOU
使用“||”可以实现同样的效果
sec@ora10g> select FIRST_NAME||FAMILY_NAME “My Name is” from t;
My Name is
Secooler HOU