（转）oracle sql%四种用法_oracle存储过程判断更新条数 %sql-优快云博客

本文详细介绍了Oracle中SQL%的四种用法：SQL%NOTFOUND用于判断update或delete操作是否找到符合条件的记录；SQL%FOUND用于判断INSERT、UPDATE或DELETE语句是否影响了一行或多行记录或SELECT INTO语句是否返回一行或多行记录；SQL%ROWCOUNT返回受影响的行数；SQL%ISOPEN用于判断SQL游标是否打开。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

oracle sql%四种用法

sql%NOTFOUND     --update,delete操作时没找到符合条件的记录。
sql%FOUND            --SELECT   columnname   INTO   ，update,delete找到符合条件的记录Top
sql%rowcount          --判定当前更新记录数
sql%isopen             --判定当前游标是否打开Top

%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.