%NOTFOUND

The %NOTFOUND is the logical opposite of the %FOUND. The %NOTFOUND yields TRUE when an INSERT, UPDATE, or DELETE statement affected no rows, or the SELECT INTO statement return no rows. Or else, the %NOTFOUND yields FALSE.

Posted Date: 10/4/2012 4:47:37 AM | Location : United States

Ask an Expert

Related Discussions:- %notfound - implicit cursor attributes, Assignment Help, Ask Question on %notfound - implicit cursor attributes, Get Answer, Expert's Help, %notfound - implicit cursor attributes Discussions

Write discussion on %notfound - implicit cursor attributes
Your posts are moderated

Write your message here..

Related Questions

Sql query for testing triggers and stored procedures , Description: Dem... Description: Demonstrate your knowledge of PL/SQL programming by writing and thoroughly testing triggers and stored procedures associated with an e-commerce application that pr

"not enforced" table constraints - sql, "Not Enforced" Table Constraints ... "Not Enforced" Table Constraints A constraint that is not enforced is not really a constraint within the meaning of the act, but SQL does have such a concept and it needs to b

Iteration schemes- iterative control, Iteration Schemes The bounds of a ... Iteration Schemes The bounds of a loop range can be variables, literals, variables, or expressions but must compute to integers. Below are some of the examples. As you can see t

Keyword & parameter description - expressions, Keyword & Parameter Descript... Keyword & Parameter Description: boolean_expression: This is an expression which yields the Boolean value that is TRUE, FALSE, & NULL. character_expression: This

Er diagrams, what are ER diagrams what are ER diagrams

Rowid - sql pseudocolumns, ROWID The ROWID returns the rowid (binary a... ROWID The ROWID returns the rowid (binary address) of a row in the database table. You can use the variables of the type UROWID to store rowids in a readable format. In the il

Sql script to create and populate the tables, Create the four tables and po... Create the four tables and populate them with the given data. Answer the following queries in SQL. 1. Get all part-color/part-city combinations. Note: Here and subsequently, the

Set operators - sql operators, Set Operators The Set operators combine... Set Operators The Set operators combine the results of the two queries into one result. The INTERSECT returns all the distinct rows selected by both queries. The MINUS returns

Out mode - parameter modes, OUT Mode An OUT parameter returns values t... OUT Mode An OUT parameter returns values to the caller of a subprogram. Within the subprogram, an OUT parameter act like a variable. That means that you can use an OUT formal

Tables within a table - sql, Tables within a Table - SQL Figure here ... Tables within a Table - SQL Figure here is an exact copy of the one in the theory book and as before it is just an alternative way of representing some of the information con