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;

Why query optimization is needed?

0 Answers  

---

if table named a is there and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time

1 Answers  

---

Can I call a procedure inside a function?

0 Answers  

---

What are stored procedures in mysql?

0 Answers  

---

What are the differences between Database Trigger and Integrity constraints ?

4 Answers  

---

How do I create a sql database?

0 Answers  

---

What is sql key?

0 Answers  

---

Can we edit a view in sql?

0 Answers  

---

Which one of the following join types will always create a Cartesian Product? 1. CROSS JOIN 2. LEFT OUTER JOIN 3. RIGHT OUTER JOIN 4. FULL OUTER JOIN 5. INNER JOIN

2 Answers  

---

Is full outer join same as cross join?

0 Answers  

---

What are pl sql procedures?

0 Answers  

---

What is a common use of group by in sql?

0 Answers  

---