oracle
coding_forever
长相一般痴迷技术城市青年爱好广泛
展开
-
OracleDBConsoleorcl无法启动_错误代码2的解决
命令行里输入emctl start dbconsole 显示Environment variable ORACLE_SID not defined. Please define it. 然后根据它的说明设置oracle_sid 命令行里输入set oracle_sid=orcl (如果你的sid不是orcl,请自己更换) 再次敲入emctl start dbconsole 显示转载 2013-06-18 09:20:15 · 917 阅读 · 0 评论 -
NO1:SQL语句(sum,decode)
select sum(decode(p.ver_month,'201305', -p.income_sum,p.income_sum)) from ODS.T_INCOME_COST_INPUT p WHERE p.ver_month in ('201305','201205') decode函数:原创 2014-06-10 10:34:23 · 2099 阅读 · 0 评论