楗洅鍗氬

涓�鑸垵瀛﹁�呭Oracle 鐨凬O_DATA_FOUND 鍜�%NOTFOUND 涓や釜淇濈暀瀛楃殑鐢ㄦ硶涓嶅浜� 瑙ｏ紝涓昏鏄畠浠粠鎰忎箟涓婃槸鏈変簺绫讳技銆傚叾瀹炲畠浠殑鐢ㄦ硶鏄湁鍖哄埆鐨勶紝灏忕粨濡備笅锛�

1 SELECT . . . INTO 璇彞瑙﹀彂 NO_DATA_FOUND锛�
2 褰撲竴涓樉绀哄厜鏍囩殑 where 瀛愬彞鏈壘鍒版椂 瑙﹀彂 %NOTFOUND锛�

3 褰揢PDATE 鎴朌ELETE 璇彞鐨剋here 瀛愬彞鏈壘鍒版椂 瑙﹀彂 SQL%NOTFOUND锛�
4 鍦ㄥ厜鏍囩殑鎻愬彇(Fetch)寰幆涓鐢� %NOTFOUND 鎴�%FOUND 鏉ョ‘瀹氬惊鐜殑閫�鍑烘潯 浠讹紝涓嶈鐢� NO_DATA_FOUND銆�

Tags : %NOTFOUND, NO_DATA_FOUND, oracle