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

What are synonyms in sql?

532

---

What is sql partition?

548

---

what is 'mysqldump'? : Sql dba

570

---

What is bulk compiling in pl/sql.?

608

---

what is oltp (online transaction processing)? : Sql dba

529

---

---

How to change the order of columns in Oracle SQL Plus ?

610

---

Why partition by is used in sql?

552

---

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

545

---

How do you truncate?

503

---

What is the size of partition table?

551

---

What is spool?

588

---

How do you create a unique index?

569

---

What does joining a thread mean?

544

---

What kind of join is join?

555

---

What is bind variable in pl sql?

526

---