最贊回答 / 蕞云天
應(yīng)為你在命令里面執(zhí)行前沒有打開屏幕輸出開關(guān), ? 寫打開,再去執(zhí)行存儲過程, ?打開的語句set serveroutput on
2018-06-04
最新回答 / 慕瓜5408684
select * from v$version獲取數(shù)據(jù)庫當(dāng)前的版本號，然後去網(wǎng)上下載對應(yīng)的JAR包。
2018-05-11
最新回答 / cmy11
select?sal,comm?into?psal?pcomm，psal?pcomm這兩個單詞之間沒有逗號分隔。這種問題應(yīng)該有提示，提問應(yīng)該把報錯提示帶上。
2018-04-13
--查詢指定員工的姓名、月薪和職位
create or replace procedure queryEmp(eno in number,
pename out varchar2,
psal out number,
pjob out varchar2)
as
begin
--得到員工的信息
select ename,sal,empjob into pename,psal,pjob from emp where empno = eno;
end;
/
沒看出錯來
create or replace procedure queryEmp(eno in number,
pename out varchar2,
psal out number,
pjob out varchar2)
as
begin
--得到員工的信息
select ename,sal,empjob into pename,psal,pjob from emp where empno = eno;
end;
/
沒看出錯來
2018-03-19
create or replace procedure Raiseaslary(eno in number)
as
psal emp.sal%type;
begin
select sal into psal from emp where empno =eno;
update emp set sal = sal+100 where empno=eno;
dbms.output.put_line('漲前：'||psal||'漲后：'||(psal+100));
end;
/
我哪里錯了
as
psal emp.sal%type;
begin
select sal into psal from emp where empno =eno;
update emp set sal = sal+100 where empno=eno;
dbms.output.put_line('漲前：'||psal||'漲后：'||(psal+100));
end;
/
我哪里錯了
2018-03-19
