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 can check sql version from command line?

0 Answers  

---

how will be date change into string

4 Answers  

---

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

0 Answers  

---

What are the two types of periodical indexes?

0 Answers  

---

What is pl sql record in oracle?

0 Answers  

---

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

0 Answers  

---

Is sql a backend language?

0 Answers  

---

Why do we use view in sql?

0 Answers  

---

Do we need commit after truncate?

0 Answers  

---

What is the difference between left outer join and left join?

0 Answers  

---

What is a heap in sql?

0 Answers  

---

Explain architecture of sql server notification services?

0 Answers  

---