已采纳回答 / 手转乾坤
declare cursor cemp is select empno ,sal from emp order by sal; --定义参数 pempno emp.empno%type; psal emp.sal%type; countEmp number :=0; salTotal number; begin --得到工资总额的初始值 select sum(sal) into salTotal from emp; --打开光标 open c...
2017-10-30
最新回答 / Lyncii
查看表的表空间SELECT TABLE_NAME,TABLESPACE_NAME FROM USER_TABLES;查看所有表空间SELECT TABLESPACE_NAME FROM DBA_TABLESPACES;
2017-10-09