摘要:
有时候查询会遇到如下错误 SCOTT@PROD> select deptno,sum(sal) from emp; select deptno,sum(sal) from emp * ERROR at line 1: ORA-00937: not a single-group group funct 阅读全文
摘要:
一。创建测试表 SCOTT@PROD> create table taotao(id number(10));Table created. 二。插入数值1到9 SCOTT@PROD> begin 2 for i in 1..9 loop 3 insert into taotao values(i); 阅读全文