Answer Posted / siva

Create or replace procedure proc(n number,s out sys_refcursor)
is
Begin
open s for select ename from emp where deptno=n;
end:

Var c ref_cursor;
exec proc(10,:c);
print : c;
Clark
King
Miller

Can a trigger call a stored procedure?

1063

---

How do we use distinct statement? What is its use?

1025

---

What is trigger in sql? Explain

981

---

how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

4004

---

How do I count duplicates in sql?

1097

---

Which tcp/ip port does sql server run?

994

---

What are the two different parts of the pl/sql packages?

1076

---

Why do we create views in sql?

1141

---

What is a Mapplet?

1116

---

What is a clob in sql?

1011

---

How can you tell the difference between an index and a view?

926

---

How does a trigger work?

1058

---

How do I start sql from command line?

1015

---

What are pl sql procedures?

1020

---

What are the parameter modes supported by pl/sql?

1094

---