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.

Which sql statement is used to return only different values?

0 Answers  

---

Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause

6 Answers   HCL,

---

Is pl sql useful?

0 Answers  

---

Is json a nosql?

0 Answers  

---

Is sql similar to python?

0 Answers  

---

---

Is a view faster than a stored procedure?

0 Answers  

---

What is the diffrence between IN and EXISTS.which one is faster.

3 Answers   Infogain,

---

what is primary key? : Sql dba

0 Answers  

---

Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.

4 Answers   Cap Gemini, IBM,

---

What is pragma in pl sql?

0 Answers  

---

What are keys in sql?

0 Answers  

---

What is a trigger in sql?

0 Answers  

---