select a.deptno ,
sum(case when sal<3000 then 1 else 0 end) ,
sum(case when sal<=6000 and sal>=3000 then 1 else 0 end) ,
sum(case when sal>6000 then 1 else 0 end) ,
nvl(sum(sal),0)
from dept a, emp b
where a.deptno = b.deptno(+)
group by a.deptno
order by a.deptno;
sum(case when sal<3000 then 1 else 0 end) ,
sum(case when sal<=6000 and sal>=3000 then 1 else 0 end) ,
sum(case when sal>6000 then 1 else 0 end) ,
nvl(sum(sal),0)
from dept a, emp b
where a.deptno = b.deptno(+)
group by a.deptno
order by a.deptno;
2017-08-24
declare
cursor cur is select empno,sal from emp order by sal;
pempno emp.empno%type;
psal emp.sal%type;
cnt number :=0;
acc emp.sal%type;
cursor cur is select empno,sal from emp order by sal;
pempno emp.empno%type;
psal emp.sal%type;
cnt number :=0;
acc emp.sal%type;
2017-08-24
begin
select sum(sal) into acc from emp;
open cur;
loop
exit when acc>50000;
fetch cur into pempno,psal;
exit when cur%notfound;
select sum(sal) into acc from emp;
open cur;
loop
exit when acc>50000;
fetch cur into pempno,psal;
exit when cur%notfound;
2017-08-24
if acc+psal*0.1<=50000 then
update emp set sal = sal*1.1 where empno=pempno;
cnt := cnt+1;
acc := acc+psal*0.1;
end if;
end loop;
dbms_output.put_line(cnt ||' '||acc);
close cur;
end;
/
update emp set sal = sal*1.1 where empno=pempno;
cnt := cnt+1;
acc := acc+psal*0.1;
end if;
end loop;
dbms_output.put_line(cnt ||' '||acc);
close cur;
end;
/
2017-08-24
已采納回答 / 昕牌肉貓
自己的親身經歷：win10 64bit，裝了11.2g的Oracle 64bit，無論怎么調（下載64bit的SQL developer也沒用），都無法調通SQL developer，感覺是32與64之間的兼容問題。win7 32bit，裝了11.2g的Oracle 32bit，很輕松就用上了SQL developer（注意要選一下java的位置，在Oracle目錄里的一個jdk的文件夾里面找）。我使用PL/SQL developer客戶端學習的這門課程，除了一些命令不能用（如accept、servero...
2017-08-18
如果是在pl/sql developer中編譯的話，只能在sql窗口中：
DECLARE
pnum number:= &num;
BEGIN
if pnum = 0 then
dbms_output.put_line('數字是0');
elsif pnum = 1 then
dbms_output.put_line('數字是1');
elsif pnum = 2 then
……
請忽略accept命令，不支持。set serveroutput on也不支持。
DECLARE
pnum number:= &num;
BEGIN
if pnum = 0 then
dbms_output.put_line('數字是0');
elsif pnum = 1 then
dbms_output.put_line('數字是1');
elsif pnum = 2 then
……
請忽略accept命令，不支持。set serveroutput on也不支持。
2017-08-17
已采納回答 / qq_aiq_2
if pjob='PRESIDENT' then update sal=sal+1000; 后面不加where 約束 會刷新表中所有數據，前面的if條件 與后面執行語句沒關系的
2017-08-16
set serveroutput on
accept num prompt '請輸入數字';
declare
pnum number:=&num;
begin
if pnum = 0 then dbms_output.put_line('輸入了0');
elsif pnum = 1 then dbms_output.put_line('輸入了1');
elsif pnum = 2 then dbms_output.put_line('輸入了2');
else dbms_output.put_line('輸入了其他數字');
end if;
end;
/
accept num prompt '請輸入數字';
declare
pnum number:=&num;
begin
if pnum = 0 then dbms_output.put_line('輸入了0');
elsif pnum = 1 then dbms_output.put_line('輸入了1');
elsif pnum = 2 then dbms_output.put_line('輸入了2');
else dbms_output.put_line('輸入了其他數字');
end if;
end;
/
2017-08-09
