oracle
云中阁
这个作者很懒,什么都没留下…
展开
-
oracle按时间段查询
with a as (select to_date('20150423','yyyymmdd')+1-(3/24)*(level-1) dt from dual connect by level select nvl(count,0) ,a.dt from a left join (select count(*) as count , a.dt from alarm_record原创 2015-10-10 13:35:18 · 1242 阅读 · 0 评论 -
Linux下自动备份Oracle数据库并删除指定天数前的备份
原文链接:http://www.osyunwei.com/archives/5960.html说明:Oracle数据库服务器操作系统:CentOSIP:192.168.0.198端口:1521SID:orclOracle数据库版本:Oracle11gR2具体操作:1、root用户登录服务器mkdir -p /backup/oracledata #新转载 2016-05-06 18:09:12 · 448 阅读 · 0 评论