oracle數(shù)據(jù)庫基礎(chǔ)第27天plsql編程

1、Plsql 進(jìn)階（條件和循環(huán)Oracle 的視圖（安全Plsql 進(jìn)階（條件和循環(huán)Oracle 的視圖（安全性，簡化查詢，磁盤空間 Plsql的高級編程（編程分頁過程模塊，下訂單過程模塊處理oraclePlsql進(jìn)階if語句使用控制語句goto 和If-If-then-If-thenelsif-java比較這看elseelse1:if-then 2000-編寫一個過程，輸入一個員工的號，輸出員工的工資和姓名set serveroutput on;createorreplaceprocedurehfc_hfc(crname-定v_salemp.sal%type; -執(zhí)selectsalintov

2、_salselectsalintov_salfromempwhere-判ifv_sal2000updateempsetsal=sal+sal*10%where-這里不識別%，只需要把這個轉(zhuǎn)換成sal=sal+sal*0.1 end if ;-使exec 2if-then-else0100，0 200；setserveroutputcreateorreplace procedurehfc_hfc(crname -定v_m%type; -執(zhí)selectcommintov_commfromempwhere-判 ifv_comm0updateempsetcomm=comm+100whereename=

3、crname; updateempsetcomm=comm+200whereename=crname; end if ;3if-then-elsif-then-else president 就給他的工資增1000manager500setserveroutputcreateorreplaceprocedurehfc_hfc(jsno -定selectjobintov_jobfromempwhereempno=jsno; if v_job=PRESIDENTthenupdateempsetsal=sal+1000whereelsifupdateempsetsal=sal+500whereempn

4、o=jsno; updateupdateempsetsal=sal+500whereempno=jsno; updateempsetsal=sal+200whereempno=jsno; end if;execjavaPlsqlusers 101-循環(huán)結(jié)構(gòu)案例1loop set serveroutput on;createorreplaceprocedurehfc_hfc(srnamevarchar2)- 定v_nonumber:=1; -執(zhí)-循insertintouser_1-退出循exitwhen-自加運end loop;-調(diào)exechfc_hfc(傻子WhileLoopwhileexechfc_hfc(傻子WhileLoopwhile true 時，才會執(zhí)行循環(huán)體語句，while while.loop end loop；結(jié)束。users 1011-案例2where循setserveroutputcreateorreplaceprocedurehfc_hfc(srnamevarchar2)- 定whilev_no=10insertint