![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle
Avril_00
Success is a lousy teacher. It seduces smart people into thinking they can't lose.
Software is a great combination between artistry and engineering.
展开
-
ora.err 总结
select ope.id,ope.nm ,ope.ace_ag_no into :clrid,:clrnm,:no FROM tb_ope ope WHERE ope.merch_id =:k1AND ope.ope_cd =:k2 ; 没找到会报 sqlca.sqlcode == 100 || sqlca.sqlcode == 1403, 【oracle】一般会报1403原创 2012-02-16 21:04:46 · 616 阅读 · 0 评论 -
Oracle分组函数之ROLLUP魅力
本文通过演示给出Oracle ROLLUP分组函数的用法,体验一下Oracle在统计查询领域中的函数魅力。ROLLUP分组函数可以理解为Group By分组函数封装后的精简用法,这里同时给出ROLLUP的Group By的改写思路。 1.初始化实验坏境 1)创建测试表group_test SECOOLER@ora11g> create table group_test (grou转载 2013-05-24 15:22:44 · 461 阅读 · 0 评论