Explain the savepoint statement.

0 Answers  

---

How can you create Cursor with parametres ?

3 Answers  

---

Is sql considered coding?

0 Answers  

---

Why do we go for stored procedures?

0 Answers  

---

What is AUTH_ID and AUTH_USER in pl/sql ?

0 Answers   INDUS,

---

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?

13 Answers   Cap Gemini, TCS,

---

How to return multiple rows from the stored procedure?

0 Answers  

---

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

4 Answers  

---

select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?

2 Answers  

---

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

0 Answers  

---

Can a trigger call a stored procedure?

0 Answers  

---

What is the trigger in sql?

0 Answers  

---