NO_DATA_FOUND鍜%NOTFOUND鐨勫樊鍒
Posted by 楗洅 on 2009骞11鏈18鏃 , No comment
涓鑸垵瀛﹁呭Oracle 鐨凬O_DATA_FOUND 鍜%NOTFOUND 涓や釜淇濈暀瀛楃殑鐢ㄦ硶涓嶅浜 瑙ｏ紝涓昏鏄畠浠粠鎰忎箟涓婃槸鏈変簺绫讳技銆傚叾瀹炲畠浠殑鐢ㄦ硶鏄湁鍖哄埆鐨勶紝灏忕粨濡備笅锛
1 SELECT . . . INTO 璇彞瑙﹀彂 NO_DATA_FOUND锛
2 褰撲竴涓樉绀哄厜鏍囩殑 where 瀛愬彞鏈壘鍒版椂 瑙﹀彂 %NOTFOUND锛
Filed under : 鏁版嵁搴