Answer / sandeep t

%sqlcount

Answer / 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 does plv msg allows you to do?

0 Answers  

---

What is the full form of sql?

1 Answers  

---

Can we join tables without foreign key?

0 Answers  

---

When you have to use a default "rollback to" savepoint of plvlog?

0 Answers  

---

What are the methods of filing?

0 Answers  

---

How do I run sql profiler?

0 Answers  

---

Why is the cursor important?

0 Answers  

---

Explain the order of sql statement execution?

0 Answers  

---

how to create a database in oracle?

3 Answers  

---

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

0 Answers  

---

What is Referential Integrity?

3 Answers  

---

What is PL/SQL table ?

6 Answers  

---