NO_DATA_FOUND
来源:互联网 发布:sql语句按降序排列 编辑:程序博客网 时间:2024/04/30 14:30
DECLARE
L_ORDERID NUMBER;
L_ITEMNO NUMBER;
BEGIN
BEGIN
SELECT EXIT(NVL(ORDERID, 0), NVL(ITEMNO, 0) INTO L_ORDERID, L_ITEMNO FROM ORDERS WHERE ORDERID = 12345;
EXCEPTION
WHEN NO_DATA_FOUND THEN
L_ORDERID := 0;
L_ITEMNO := 0;
END;
END;
- NO_DATA_FOUND
- no_data_found
- 避免NO_DATA_FOUND
- 关于NO_DATA_FOUND和%NOTFOUND
- oracle pl sql NO_DATA_FOUND
- oracle异常之no_data_found
- no_data_found的解决方法
- NO_DATA_FOUND 与 %NOTFOUND的区别
- 避免selet into的no_data_found
- ORACLE SELECT INTO NO_DATA_FOUND问题
- NO_DATA_FOUND 和 %NOTFOUND的区别
- PL/SQL的No_data_found例外
- select count(*) into 也会报 NO_DATA_FOUND 异常?!
- oracle数据库存储过程中NO_DATA_FOUND不起作用?
- 关于select into NO_DATA_FOUND的处理
- ORACLE NO_DATA_FOUND的三种处理办法
- ODBC的Oracle驱动的关于no_data_found的BUG
- Oracle触发器中select into 报错no_data_found异常处理
- WinCE嵌入式开发程序入门
- 2009.02.11
- 小视不得!WinImage打造超强启动盘
- 勇敢面对人生,真诚对待自己
- spring+hibernate中的Result object returned from HibernateCallback isn't a List
- NO_DATA_FOUND
- 动画流程的思考
- TOMCAT IOException while loading persisted sessions: java.io.EOFException
- Quizfarm
- 发现一款强大的自动采集软件myspider
- 重构并非设计的替代品
- maven入门2
- 暴笑笑话集
- WORD2003无法打开WORD2000文档解决方法