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 function and procedure?

1080

---

What is the difference between syntax error and runtime error?

1185

---

What are all types of user defined functions?

1140

---

Is time a data type in sql?

964

---

What is the largest value that can be stored in a byte data field?

1060

---

Is crud a cuss word?

1075

---

What is trigger in sql? Explain

1046

---

Explain aggregate functions are available there in sql?

1051

---

what is a trigger in mysql? : Sql dba

1216

---

How do I turn a list into a table?

1016

---

Does a primary key have to be a number?

1008

---

Why do we create views in sql?

1220

---

How do you create a db file?

1071

---

What is synchronized subquery?

1224

---

What is sql indexing?

1065

---