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;

What is the difference between numeric and autonumber?

992

---

What is primary key and foreign key?

958

---

How to add new employee details in an employee_details table with the following details

1085

---

What is the difference between python and sql?

995

---

What are database links used for?

1040

---

What is a join?

1057

---

What are all different types of collation sensitivity?

1025

---

How you improve the performance of sql*loader? : aql loader

1009

---

Explain architecture of sql server notification services?

1054

---

What is pragma in sql?

1071

---

how can you create an empty table from an existing table? : Sql dba

1152

---

Which is better join or inner query?

1039

---

What is difference between pls_integer and integer?

950

---

How do you identify a primary key?

1061

---

Is sql the best database?

965

---