sql%NOTFOUND update,delete操作時沒找到符合條件的記錄。
sql%FOUND SELECT columnname INTO ﹐update,delete找到符合條件的記錄
sql%FOUND SELECT columnname INTO ﹐update,delete找到符合條件的記錄
解决方案 »
- 关于项目中使用系统统一序列还是单表独立序列
- 怎样使数据库启动时自动读取指定的初始化文件
- ODBC (oracle in oraHome92)连接oracle 11g显示 ORA-01017 登陆被拒绝什么原因?
- oracle用plsql有些语句找不解释,请问大家是在哪里找帮助的?
- 请问怎么把本机的归档日志备份到局域网的另一台机子上?
- 在VB.Net 中如何用oo4o获取自定义对象类型中的日期类型
- [求助]关于SQL方面的优化问题!!!
- UTL_SMTP发送email指定authentication问题
- ORACLE练习题 求指教
- 虚拟机下Linux下安装Oacle11g rac 中出现第六步rac2节点找不到
- ORACLE 8.1.6 目录服务访问怎么配置???
- 在oracle9i中如何看到数据库中的全部表
sql%isopen --判定当前游标是否打开
SQL
This is the name of the implicit SQL cursor. %FOUND
This attribute yields TRUE if an INSERT, UPDATE, or DELETE statement affected one or more rows or a SELECT INTO statement returned one or more rows. Otherwise, it yields FALSE. %ISOPEN
This attribute always yields FALSE because Oracle closes the SQL cursor automatically after executing its associated SQL statement. %NOTFOUND
This attribute is the logical opposite of %FOUND. It yields TRUE if an INSERT, UPDATE, or DELETE statement affected no rows, or a SELECT INTO statement returned no rows. Otherwise, it yields FALSE. %ROWCOUNT
This attribute yields the number of rows affected by an INSERT, UPDATE, or DELETE statement, or returned by a SELECT INTO statement.