suiyi_99的博客

select list_name ,pattern ,regexp_replace(regexp_replace(pattern, '^.*?:', ''), ',.*?:', '/','g') ,regexp_replace(pattern, '^.*?:', '') from insp_listregexp_replace(string text,pattern text, replacement text[, flags text])将匹配posix正则

1.将数值转成字符串类型：to_char(int, text)int为要转换的值，text为数值格式化模式其中 “模式” 描述：9 带有指定数值位数的值；0 带前导零的值；.(句点) 小数点；,(逗号) 分组(千)分隔符例：SELECT to_char(12345, '') //结果''SELECT to_char(12345, '99999')//结果‘12345’SELECT to_char(12345, '9999999999999999999')//结果‘12345’，结果字

ROW_NUMBER() OVER( [ PRITITION BY col1] ORDER BY col2[ DESC ] )ROW_NUMBER()为返回的记录定义个行编号，PARTITION BY col1是根据col1分组，ORDER BY col2[ DESC ]是根据col2进行排序。SELECT ename,deptno ,sal,ROW_NUMBER()OVER(PARTITION BY deptno ORDER BY sal DESC) AS group_rankFROM emp