2018年2月3日
oracle按照指定列分组合计group by rollup()
group by rollup() 按分组合计 select grouping(status),status,owner,object_type,count(*) from dba_objects where owner not in ('SYS','SYSTEM') group by rollup Read More
posted @ 2018-02-03 22:27 秦先生的客栈 Views(1943) Comments(0) Diggs(0) Edit
oracle查看哪些表被锁
select b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects b where a.object_id = b.object_id Read More
posted @ 2018-02-03 22:25 秦先生的客栈 Views(258) Comments(0) Diggs(0) Edit
oracle按照指定列排序操作
按照...分组排序后，得到行编号: row_number() over(partition by ... order by ...) 按照...分组排序后，得到相应的列的第一个数据： first_value(列名或列位置) over(partition by ... order by ...) Read More
posted @ 2018-02-03 22:22 秦先生的客栈 Views(1501) Comments(0) Diggs(0) Edit
oracle中实现当前月减少或增加N个月
add_months(last_day(trunc(sysdate)),N)N可以为正，表示增加；N可以为负，表示减少。 Read More
posted @ 2018-02-03 22:13 秦先生的客栈 Views(1714) Comments(0) Diggs(0) Edit
cmd远程连接oracle
sqlplus 用户名/密码@IP:端口号/oracle实例 Read More
posted @ 2018-02-03 22:07 秦先生的客栈 Views(279) Comments(0) Diggs(0) Edit