ypc95221的博客

以XE数据库中的employees表为例 获得所有员工入职的具体时间的年月日select first_name||' '||last_name as 姓名,to_char(sysdate,'YYYY/MM/DD') 当前时间,hire_date 入职时间,(trunc(trunc(months_between(sysdate,hire_date))/12))||'年'||(trunc(m

做报表需要给各车间的数据显示到一起，每行显示三个车间的数据，按照分组的序号换行显示DENSE_RANK() OVER(ORDER BY b.dept_name) grp --整段select * from (select m.jxcdl,              DENSE_RANK() OVER(ORDER BY b.dept_name) grp,            ...

select t.dept, t.father_type, t.child_type, regexp_substr(t.child_type, '[^,]+', 1, L) as c, L from rc_dcz_type t, (select LEVEL L from dual connect by LEVEL <= 20) ...