Answer / nitin

Possibe Scenarios
1. Check table is being locked by any other resourse.
2. Table reach to HIGH WATER MARK, resuse the storage or SHINK SPACE could overcome this problem.
3. Check the data volume.
4. Table or index(if any) is analysed or their stats are gather or not.

Answer / nitinsharma06

1.Table is being Locked by any other resourse or not.
2.Table is reach to high water mark, REUSE STORAGE or SHRINK SPACE could resolve the issue.
3.Table or Indx(if any) stats are gather or not.

How to run sql functions in pl/sql?

0 Answers  

---

Which normal form is best?

0 Answers  

---

How does a covering index work?

0 Answers  

---

What is serial sql?

0 Answers  

---

What is sap sql anywhere?

0 Answers  

---

---

What is trigger in pl sql with examples?

0 Answers  

---

overloading of stored procedure is possible in oracle?

3 Answers   Nelco,

---

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 only how should u write query?

9 Answers   TCS,

---

Explain what is a column in a table?

0 Answers  

---

write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.

3 Answers   Zensar,

---

What is a stored procedure in sql with example?

0 Answers  

---

I have a table .in the table 100 recored is there .we have get the single row with out using clause..

3 Answers  

---