分类(Oracle)
Oracle SQL 游标用法
2008/10/29 09:53

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.    

Tags: Oracle
相关日志:
+引用(0) |
发表评论
昵称  密码  游客无需密码
网址  电邮  注册
验证码 请输入左侧图片中的字符
记住我