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;

how to load data files into tables with 'mysqlimport'? : Sql dba

0 Answers  

---

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

0 Answers  

---

How does left join work in sql?

0 Answers  

---

Explain how exception handling is done in advance pl/sql?

0 Answers  

---

What is the difference between sum and count in sql?

0 Answers  

---

How do you concatenate in sql?

0 Answers  

---

How do I run pl sql in sql developer?

0 Answers  

---

i want to display 1 to 10 numbers using one select statement.

18 Answers   HCL, Nyros, Oracle,

---

What is numeric function sql?

0 Answers  

---

In testing where do we use sql language and how it helps in testing?

2 Answers  

---

What is serial sql?

0 Answers  

---

who introduced sql?

0 Answers  

---