![](https://img-blog.csdnimg.cn/20201014180756757.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle常用函数
星恋tt
记录开发及学习过程点滴,不断提升自己
展开
-
ORACLE常用函数([正则函数regexp_substr])
**ORACLE正则函数(regexp_substr):**根据指定字符将oracle行转列处理,如下列脚本则按照“,”对字符进行分割with test as (select '001' xa,'a,b,c,d' xb from dualunionselect '002' xa ,'a,c,b,e' xb from dual)select x.xa,regexp_substr(x.xb,'[^,]+',1,level) xb from test x connect by level <原创 2021-07-01 16:27:14 · 194 阅读 · 0 评论 -
ORACLE常用函数([行转列pivot] [列转行unpivot])
ORACLE行转列函数(pivot):with test as (select '001' stu_num,'数学' stu_class,100 stu_score from dualunionselect '001' stu_num,'语文' stu_class,63 stu_score from dualunionselect '001' stu_num,'英语' stu_class,90 stu_score from dualunionselect '002' stu_num,'数学'原创 2021-07-01 16:03:42 · 186 阅读 · 0 评论