What are the Diff B/W Cursor and REF Cursor

3 Answers   CTS,

---

i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts with values 1000,2000,3000 for c and 4000,5000,8000 for d.i need to find the sum of these accounts c and d individually and find the differences between their sum using one select statement.

11 Answers   Ebix, Hewitt,

---

Hi all, i have a table as follows empid empname mgrid deptid 1 a 3 4 2 b 1 5 3 c 2 3 4 d 3 6 5 e 4 7 i want the output as empname mgrname a c b a c b d c e d

4 Answers  

---

counting the no.of characters occurs in a string by using pl/sql function

1 Answers   TCS,

---

What is the command used to fetch the first 5 characters of a string?

0 Answers  

---

What is the use of sql trace?

0 Answers  

---

What is the execution plan in sql?

0 Answers  

---

What are pl/sql packages?

0 Answers  

---

Write a query to find second highest salary of an employee.

27 Answers  

---

how is myisam table stored? : Sql dba

0 Answers  

---

How can we overcome recursive triggers in SQL?

1 Answers   iFlex,

---

What is column?

0 Answers  

---