如何遍歷所有記錄，不用每次輸入特定的值去查詢。那么我們使用Oracle游標
游標分為：靜態游標和引用游標（動態游標）
靜態游標：由用戶定義（隱式游標、顯示游標）結果集不變
引用游標游標：結果集變化
隱式游標：用DML操作時，自動使用隱式游標。我們可以使用隱式游標判斷SQL語句執行結果
自動聲明和處理的。在Session會話區，開啟游標。處理后自動關閉。可以返回單行查詢。
隱式游標使用：
declare
%NOTFOUND －－ 執行行沒有找到。
%FOUND －－執行行找到
%ROWCOUNT －－游標影響行數
%ISOPEN －－ 當前游標是否打開
我們現在通過游標來看看上篇文章的例子
通過循環來遍歷數據：
1、loop when循環
declare
cursor myCur is select * from hr.jobs;
oneRow hr.jobs%rowtype;
begin
open myCur;
loop
fetch myCur into oneRow;
dbms_output.put_line(oneRow.job_id ||' ' ||onerow.job_title);
exit when myCur%notFound;
end loop;
close myCur;
end;
2、while 循環
declare
cursor myCur is select * from hr.jobs;
oneRow hr.jobs%rowtype;
begin
open myCur;
fetch myCur into oneRow;
while (myCur%found)
loop
dbms_output.put_line(oneRow.job_id ||' ' ||onerow.job_title);
fetch myCur into oneRow;
end loop;
close myCur;
end;
3、for 循環
declare
cursor myCur is select * from hr.jobs;
oneRow hr.jobs%rowtype;
begin
for oneRow in myCur loop
dbms_output.put_line(oneRow.job_id ||' ' ||onerow.job_title);
end loop;
end;
結果如下：
AD_PRES President
AD_VP Administration Vice President
AD_ASST Administration Assistant
FI_MGR Finance Manager
FI_ACCOUNT Accountant
AC_MGR Accounting Manager
AC_ACCOUNT Public Accountant
SA_MAN Sales Manager
SA_REP Sales Representative
PU_MAN Purchasing Manager
PU_CLERK Purchasing Clerk
ST_MAN Stock Manager
ST_CLERK Stock Clerk
SH_CLERK Shipping Clerk
IT_PROG Programmer
MK_MAN Marketing Manager
MK_REP Marketing Representative
HR_REP Human Resources Representative
PR_REP Public Relations Representative
作者：tshfang
