阿杜童鞋的博客

concat：连接字符串。如：select concat("a","b") from xxx 结果：abconcat_ws：连接字符串，在连接的多个字符串之间增加需要的关键字select concat_ws(",","1","2"，"3") from xxx 结果：1,2,3substr:：分割字符串如：select substr("abcdefg

去除两边空格SELECT TRIM(' 123 ') from xxx 结果123去除左边空格SELECT LTRIM(' 123') from xxx 结果123去除右边空格SELECT RTRIM('123 ') from xxx 结果123去除两边指定字符SELECT TRIM(BOTH '000' FROM '000123000'); 结果123去除...

select PGM_ID,PGM_SH_CFM_CD,row_number() over(partition by PGM_ID order by PGM_SH_CFM_CD)rn,count(*) over(partition by PGM_ID) cnt from MED_PGM_SH_CFM_H查出的数据如下 最近使用到了ORACLE的分析函数随手记录一下。over...