What is group by in sql?

0 Answers  

---

How do I make my sql query run faster?

0 Answers  

---

What are actual parameters and formal parameters?

0 Answers  

---

I have 2 packages A and B. Now package A references Package B and Package B references Package A. How do you compile such inter-dependent objects in PL/SQL

5 Answers   Doyensys, Infosys, Metric Stream,

---

type type_name is table of varchar2(30) index by binary_integer for the above type you have to create a identifier... like identifier_name type_name; for the above type you can use the below methods..like first , last , prior, next , delege..etc...like this.. if you create a cursor...like cursor cursor_name is select * from scott.emp; is there any methods like above to use prior, fist , last , next , trim ,etc...

1 Answers   Satyam,

---

What are sql data types?

0 Answers  

---

what's the difference between a primary key and a unique key? : Sql dba

0 Answers  

---

What is trigger explain it?

0 Answers  

---

i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example empno ename mgr_id 1 john 3 2 paul 3 3 smith 1 4 kevin 1 5 stewart 2 result has to look like this ename manager john smith paul smith smith john kevin john stewart paul can u plz help me out in this.....

8 Answers  

---

Describe different types of general function used in sql?

0 Answers  

---

explain mysql aggregate functions. : Sql dba

0 Answers  

---

Which query operators in sql is used for pattern matching?

0 Answers  

---