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帳號(hào)
http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
共享下我的oracle帳號(hào)
2018-05-19
對(duì)新手來說,太簡(jiǎn)略了,聽了還沒明白什么意思下一個(gè)一大堆代碼就出來了,不適合新手學(xué)習(xí)
2018-05-11
安裝能不能一步步來提示一下?出錯(cuò)率很麻煩啊,弄了一整天還是出錯(cuò),有點(diǎn)要崩潰了,有哪位大神可以指導(dǎo)一下的嗎
2018-05-04