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

How are functions and procedures called in PL/SQL?

1230

---

How do I run a query in pl sql developer?

996

---

What is database migration?

970

---

Explain the the delete statements in sql?

1063

---

what is the difference between join and union? : Sql dba

1113

---

What is cross join sql?

917

---

Explain the select statement in sql?

1112

---

What is AUTH_ID and AUTH_USER in pl/sql ?

2193

---

what are string data types? : Sql dba

1045

---

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1120

---

Explain two easy sql optimizations.

1013

---

What is crud stand for?

998

---

Which join is default?

954

---

give the syntax of grant and revoke commands? : Sql dba

1153

---

What does the sign mean in sql?

989

---