what is the need of the cursor attribute notfound..(because
using found attribute we can complete the task......found +
negation operator = not found )
Answer Posted / manoranjan sethy
As per as cursor attribute concept are concern %notfound attributes are used in order of to terminate the condition.
Using found with negation like not (c1%found) we can even exit from the condition but instead of writing %NOTFOUND attribute why should I use unnecessarily two operator (like, not)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is mutating trigger?
What is online transaction processing (oltp)?
Which kind of parameters cannot have a default value in pl sql?
What is sp_helptext?
what are the types of join and explain each? : Sql dba
what is an alias command? : Sql dba
what is a primary key? : Sql dba
Is sqlite thread safe?
How to write html code in pl sql?
What are inbuilt functions in sql?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
How many types of relationship are there?
What is microsoft t sql?
Show the two pl/sql cursor exceptions.
Are stored procedures faster than dynamic sql?