Answer / ramesh kotha

exex dbms_stats.gather_table_statistics
('<schema>','<tablename>');

Answer / senthil vinayagam

Using analyze command

what is the difference between implicit and explicit trigger

2 Answers   Tech Mahindra,

---

How do I start sql from command line?

0 Answers  

---

Difference between SUBSTR and INSTR?

3 Answers  

---

Name some usages of database trigger?

0 Answers  

---

A table has 150 records. How do you retrieve 100th row to 120th row from that table ?

21 Answers   IBM,

---

---

How many joins can you have in sql?

0 Answers  

---

how i do the database testing of online money transactions between two parties (client and organization). suppose our company makes a website for our client and give a extra feature of online money transaction with there clients then how i test this feature in database testing

1 Answers  

---

What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no difference. 2. A PRIMARY KEY cannot be declared on multiple columns. 3. A UNIQUE CONSTRAINT cannot be declared on multiple columns. 4. A table can have multiple PRIMARY KEYS but only one UNIQUE CONSTRAINT. 5. A table can have multiple UNIQUE CONSTRAINTs but only one PRIMARY KEY.

7 Answers   Satyam,

---

When the mutating error will comes? and how it will be resolved?

2 Answers  

---

how can we know the number of days between two given dates using mysql? : Sql dba

0 Answers  

---

How to fetch alternate records from a table?

0 Answers  

---

What is clause?

0 Answers  

---