Answer / babu

The notfound attribute as far as i know is being used to
set the exit condition for the cursor.Yes,found with
negation like NOT(c1%found) can be used instead of notfound.

Answer / 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 t sql a programming language?

0 Answers  

---

define a variable representing the expression used to calculate on emps total annual remuneration.use the variable in a statement which finds all emps who can earn 30000 a year or more.

5 Answers  

---

How to call DDL statements from pl/sql?

5 Answers  

---

i want to display 1 to 10 numbers using one select statement.

18 Answers   HCL, Nyros, Oracle,

---

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

0 Answers  

---

---

What is benefit of creating memory optimized table?

0 Answers  

---

Display the total debit counts, total credit counts, sum of total debits, sum of total credits from an employee's transaction table (a single table) containing the following columns. Transaction_number Transaction_amount Transaction_date Transaction_type --> tells if the amount is a credit or a debit. As the query alone is important, the table is left with specifying just the field's name. Pls help me with this query.

3 Answers   iNautix, Oracle,

---

difference between pl/sql table and normal pl/sql table

2 Answers  

---

what are the advantages of primary key over unique+notnull

7 Answers   Consultancy, LGS, Oracle,

---

Can you join a table to itself?

0 Answers  

---

Is sql the best database?

0 Answers  

---

How to come back in normal stage in Mutating Table if mutating table is locked or update data?

2 Answers  

---