qq_37863582的博客

1.行转列1.1实现：select regexp_substr(name,'[^,]+',1,level) as namefrom t connect by level <= (length(translate(name,','||name,','))+1);1.2实现：select depno,sum(decode(job,'salesman',sal,0))...

1.substr字符串截取格式：subtr(字符串X,n,m) 从第n位开始到第m位截取字符串Xselect substr('hello',1,3) from dual;----结果：hel2.replace和translate字符替换replace是字符串的替换，格式：replace(字符串X，A,B) 将字符串X中的A替换为Btranslate是单个字符替换，格式：tra...