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)

Explain the savepoint statement.

0 Answers  

---

What is the Subquery?

4 Answers  

---

Can we interchange parameters in procedure while calling

1 Answers   TCS,

---

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?

13 Answers   Cap Gemini, TCS,

---

What are system versioned tables?

0 Answers  

---

---

I have a package in which a table was used in a procedure and compiled later i have dropped the table used in the package what would be the status of package specification and body

1 Answers   TCS,

---

counting the no.of characters occurs in a string by using pl/sql function

1 Answers   TCS,

---

Explain UNION,MINUS,UNION ALL, INTERSECT?

1 Answers  

---

What is rownum?

0 Answers  

---

What is rownum and rowid?

0 Answers  

---

oracle is compiler or interpretter,can any one tell me the answer?

9 Answers   Satyam,

---

What is a .db file?

0 Answers  

---