Answer Posted / nishi
NO_DATA_FOUND is pre defind exception of oracle. when we can't get any data from the table for any query. In that case we will get error.
%NOT FOUND is one of the attribute of explicit cursor. when can't get any data from explicit cursor in that case
%NOT FOUND will returns true otherwise it returns false.
Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Can group functions be mixed with non-group selection fields?
What is system tablespace?
Can select statements be used on views in oracle?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
Can we use bind variables in oracle stored procedure?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
How to increment dates by 1 in oracle?
How data locks are respected in oracle?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
Explain the use of record length option in exp command.
What are the attributes of cursor?
What are nested tables?
Differentiate between translate and replace?
What is a trace file and how is it created in oracle?
What are the differences between char and nchar in oracle?