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

Does view contain data?

1078

---

What is string data type in sql?

1210

---

What kind of join is join?

1006

---

Can we insert in sql function?

1138

---

How does sql store data?

953

---

Can we insert data into view?

947

---

What is %type in sql?

1006

---

Why is a trigger used?

988

---

Can we join same table in sql?

1063

---

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1196

---

What is coalesce sql?

1049

---

what is the difference between inner and outer join? Explain with example. : Sql dba

1058

---

What are the different schemas objects that can be created using pl/sql?

1079

---

How to check if a column is nullable before setting to nullable?

1174

---

Which join is like an inner join?

1091

---