Question: what is notfound in oracle?
Answer: %NOTFOUND Attribute A cursor attribute that can be appended to the name of a cursor or cursor variable. Before the first fetch from an open cursor, cursor_name%NOTFOUND returns NULL . Thereafter, it returns FALSE if the last fetch returned a row, or TRUE if the last fetch failed to return a row.