Answer Posted / karthik

U define a variable in the SQL Prompt as ref cursor Before
that u have to write a procedure with a sys ref cursor as a
inout parameter.Then execute the procedure by passing the
variable defined in the SQL prompt and print the variable It
will display the records.

declare

cursor v_cursor is

select empno empnm empdept from emp where empdept 10;

begin

open v_cursor;

loop

fetch v_cursor into c_empno c_empnm c_empdept;

exit when v_cursor notfound;

dbms_output.put_line(c_empno || ' | ' || c_empnm || ' | ' ||
c_empdept );

end loop;

close v_cursor;

end;

How do you write a complex sql query?

1077

---

What is string data type in sql?

1140

---

What is a system versioned table?

986

---

Mention what is the use of function "module procedure" in pl/sql?

1049

---

Explain character-manipulation functions?

1133

---

What is schema in sql example?

1179

---

How to run pl sql program in mysql?

1020

---

How many triggers can be applied to a table?

1063

---

Why do we use function in pl sql?

1061

---

What is the difference between database trigger and stored procedure?

1074

---

Explain the purpose of %type and %rowtype data types?

928

---

How do I find duplicates in a single column in sql?

1020

---

How many triggers can be applied on a table?

935

---

What is a relationship and what are they?

1152

---

How to select all records from the table?

1136

---