如题所述
è¿æ¯ç¨äºæ¸¸æ å¤ææ¯å¦è¿ææ°æ®çï¼
Oracle游æ 常ç¨å±æ§ï¼
%FOUNDï¼åéæåä»æ¸¸æ ä¸è·åè®°å½çæ¶åï¼å¨ç»æéä¸æ¾å°äºè®°å½ã
%NOTFOUNDï¼åéæåä»æ¸¸æ ä¸è·åè®°å½çæ¶åï¼å¨ç»æéä¸æ²¡ææ¾å°è®°å½ã
æ¯å¦ï¼
12345678910111213141516171819202122232425262728293031Cursor emps is Select * from employees where rownum<6 order by 1; Emp employees%rowtype; Row number :=1; Begin Open emps; /* æå¼éæ游æ */ Fetch emps into emp; /* 读å游æ å½åè¡ */ Loop If emps%found then Dbms_output.put_line('Looping over record '||row|| ' of ' || emps%rowcount); Fetch emps into emp; Row := row + 1; Elsif emps%notfound then Exit; End if; End loop;
Oracle游æ 常ç¨å±æ§ï¼
%FOUNDï¼åéæåä»æ¸¸æ ä¸è·åè®°å½çæ¶åï¼å¨ç»æéä¸æ¾å°äºè®°å½ã
%NOTFOUNDï¼åéæåä»æ¸¸æ ä¸è·åè®°å½çæ¶åï¼å¨ç»æéä¸æ²¡ææ¾å°è®°å½ã
æ¯å¦ï¼
12345678910111213141516171819202122232425262728293031Cursor emps is Select * from employees where rownum<6 order by 1; Emp employees%rowtype; Row number :=1; Begin Open emps; /* æå¼éæ游æ */ Fetch emps into emp; /* 读å游æ å½åè¡ */ Loop If emps%found then Dbms_output.put_line('Looping over record '||row|| ' of ' || emps%rowcount); Fetch emps into emp; Row := row + 1; Elsif emps%notfound then Exit; End if; End loop;
温馨提示:答案为网友推荐,仅供参考