if saltotal+psal*0.1<50000 then
update emp set sal=sal*1.1 where empno=pemno;
countemp:=countemp+1;
saltotal:=saltotal+psal*0.1;
end if;
update emp set sal=sal*1.1 where empno=pemno;
countemp:=countemp+1;
saltotal:=saltotal+psal*0.1;
end if;
2018-06-07
--使用基本變量類型
SET SERVEROUTPUT ON
declare
pnumber number(7,2);
pname varchar2(10);
pdate date;
begin
pnumber :=1;
pname :='tom';
pdate :=sysdate;
dbms_output.put_line(pnumber);
dbms_output.put_line(pname);
dbms_output.put_line(pdate);
dbms_output.put_line(pdate+1);
end;
/
SET SERVEROUTPUT ON
declare
pnumber number(7,2);
pname varchar2(10);
pdate date;
begin
pnumber :=1;
pname :='tom';
pdate :=sysdate;
dbms_output.put_line(pnumber);
dbms_output.put_line(pname);
dbms_output.put_line(pdate);
dbms_output.put_line(pdate+1);
end;
/
2018-05-19
Oracle sql Developer:http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
Mysql Java JDBC :https://dev.mysql.com/downloads/file/?id=477058
Mysql Java JDBC :https://dev.mysql.com/downloads/file/?id=477058
2018-05-19
sql Developer下載地址:
http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
共享下我的oracle帳號
http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
共享下我的oracle帳號
2018-05-19
安裝能不能一步步來提示一下?出錯率很麻煩啊,弄了一整天還是出錯,有點要崩潰了,有哪位大神可以指導(dǎo)一下的嗎
2018-05-04