How global cursor can be declare with dynamic trigger ?

0 Answers  

---

Do we need commit after truncate?

0 Answers  

---

What is the starting oracle error number?

0 Answers  

---

What cursor type do you use to retrieve multiple recordsets?

17 Answers   Apollo, CTS, IonIdea, Microsoft, Oracle, TCS, Vmoksha, Wipro,

---

What is the use of desc in sql?

0 Answers  

---

how to decrement dates by 1 in mysql? : Sql dba

0 Answers  

---

A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to create hierarchy.

2 Answers   TCS,

---

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

0 Answers  

---

In table three columns with 1 milion records(here there is no sequence values) i want add one more column with sequence values from the first how it is posible?

4 Answers   Tech Soft,

---

What problem one might face while writing log information to a data-base table in pl/sql?

0 Answers  

---

Is it possible to sort a column using a column alias?

0 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,

---