Difference between NO DATA FOUND and %NOTFOUND?
Answer / 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 |
What is a sub query? Describe its types?
Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
What would you do with an in-doubt distributed transaction?
What types of joins are used in writing subqueries?
does the query needs a hint to access a materialized view?
write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c
What is blob datatype?
What is the difference between alert log file and tarce file ?
What happens to indexes if you drop a table?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
What is a synonym? What are its various types?
How to select all columns of all rows from a table in oracle?