oralce
liuguocheng
开心,快乐,坦诚,大方。
展开
-
oracle统计一年中每个月的数据
第一种写法: SELECT SUM(DECODE(EXTRACT(MONTH FROM B.TIMES), 1, B.PRICE, 0)) AS A, SUM(DECODE(EXTRACT(MONTH FROM B.TIMES), 2, B.PRICE, 0)) AS B, SUM(DECODE(EXTRACT(MONTH FROM B.TIMES), 3, B.P原创 2013-10-10 17:19:52 · 1554 阅读 · 0 评论 -
ORACLE 存储过程被锁,编译不了,怎么解锁?
可用SYS登录,然后查询如下语句: 查找存储过程OPERATIONDATA_IMP被哪些session锁住而无法编译 select * FROM dba_ddl_locks where name =upper('OPERATIONDATA_IMP'); 从而得到session_id,然后通过 select t.sid,t.serial# from v$session t where t.sid原创 2014-02-25 13:48:14 · 790 阅读 · 0 评论 -
linux 服务器导出dmp到当前服务器
linux 服务器导出dmp su oracle export ORACLE_HOME=/oracle/product/10g export PATH=$ORACLE_HOME/bin:$PATH export ORACLE_SID=orcl exp test/test full=y file=/home/oracle/hyzl_server.dmp log=/home/oracle/hyzl_原创 2014-02-20 15:16:36 · 730 阅读 · 0 评论 -
redhat oracle备份
#!/bin/sh #echo "back hyzl begin" rq=`date +%Y%m%d` #echo $rq logpath="/home/backup/logs/hyzl_$rq" #echo $logpath su - oracle -c "/oracle/product/10g/bin/exp hyzl_web/test owner=hyzl_web file=/home/原创 2014-04-16 16:12:39 · 546 阅读 · 0 评论 -
安装oracle
详见: http://www.cnblogs.com/mchina/archive/2013/03/08/2934473.html http://a455360448201209214217.iteye.com/blog/1883133 http://jingyan.baidu.com/article/bad08e1e9900ec09c8512105.html http://www.cnb原创 2015-08-11 13:54:25 · 354 阅读 · 0 评论