Answer / abhisekh

we can call a procedure using 2 ways
1.using exec <procedure>
2.using anonymous block< begin <procedure> end;
now coming to ur questions answer. crate a anonymous block and add the statements u wanted to execute first then call the procedure.

What is record in pl sql?

0 Answers  

---

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 only how should u write query?

9 Answers   TCS,

---

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

0 Answers  

---

How do you drop a trigger?

0 Answers  

---

What is integrity constraints?

5 Answers   Ramco, Satyam,

---

---

what are the different index configurations a table can have? : Sql dba

0 Answers  

---

What are different sql data types?

0 Answers  

---

What is NOCOPY?

6 Answers   DELL,

---

How to run pl sql program in mysql?

0 Answers  

---

Show how functions and procedures are called in a pl/sql block.

0 Answers  

---

How do I partition in sql?

0 Answers  

---

What is dml with example?

0 Answers  

---