What is different between NO DATA FOUND and %NOT

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is different between NO DATA FOUND and %NOTFOUND

NO DATA FOUND is an exception which is raised when either an implicit query returns no data, or you attempt to reference a row in the PL/SQL table which is not yet defined. SQL%NOTFOUND, is a BOOLEAN attribute indicating whether the recent SQL statement does not match to any row.

(Continued on next question...)

Other Job Interview Questions

• Can you clone from multi node system to single node system and vice versa ?
• Can C driver in application patch create Invalid Object in database ?
• Where is appsweb.cfg or appsweb_$CONTEXT.cfg stored and why its used ?
• Where is HTML Cache stored in Oracle Applications Server ?
• What is difference between AD_BUGS and AD_APPLID_PATCHES ?
• What is GWYUID ?
• What is plssql/database cache ?
• What is difference between UNIQUE and PRIMARY KEY constraints?
• What are ORACLE PRECOMPILERS?
• What is RRA/FNDFS ?
• More...