explain mysql aggregate functions. : Sql dba

0 Answers  

---

What is the use of function "module procedure" in pl/sql?

0 Answers  

---

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 Answers   Oracle, TCS,

---

What is a call statement? Explain with an example.

0 Answers  

---

what are the type of locks ? : Sql dba

0 Answers  

---

---

what is the use of friend function? : Sql dba

0 Answers  

---

I have a CURSOR then why we need BULK COLLECT again?

1 Answers  

---

Explain about various levels of constraint.

0 Answers  

---

what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?

3 Answers   HCL,

---

explain advantages of myisam over innodb? : Sql dba

0 Answers  

---

What is union, minus and interact commands?

0 Answers  

---

What is record data type?

0 Answers  

---