select deptno,count(distinct empno) from ps_employee group by deptno;select deptno,min(adr_date) from ps_employee group by deptno;select deptno,to_char(adr_date,'yyyy-mm'),count(distinct empno) from ps_employee where adr_date is not null group by deptno,to_char(adr_date,'yyyy-mm')select deptno,to_char(LEV_DATE,'yyyy-mm'),count(distinct empno) from ps_employee where LEV_DATE is not null group by deptno,to_char(LEV_DATE,'yyyy-mm')select * from ps_employee where months_between(sysdate,bir_date)/12>30
编写一个函数,将具有某个特殊分隔符的字符串转成数组:
如字符串 UASD1M,123,1882,IID
根据分割符 , 分别将 UASD1M 123 1882 IID 存入数组中(用Oracle完成) .寫一個函數(用Oracle完成)
傳遞的值是: {name}test{worker_id}S0888{EMAIL}[email protected] 等 以{}+value形式的一串有規則字符
r要求根據{}中的內容得到value
如果 輸入{name},則得到test
輸入{worker_id},則得到S0888