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;

can we delete the trigger in a view? if yes why if not why?

5 Answers   Tech Mahindra,

---

Explain the usage of WHERE CURRENT OF clause in cursors ?

4 Answers   Satyam,

---

How many functions are there in sql?

0 Answers  

---

What is meaning of <> in sql?

0 Answers  

---

What is application trigger?

0 Answers  

---

What is memory optimized table?

0 Answers  

---

How do I view an execution plan in sql?

0 Answers  

---

what is the difference between rownum pseudo column and row_number() function? : Sql dba

0 Answers  

---

how do you login to mysql using unix shell? : Sql dba

0 Answers  

---

I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.

7 Answers   MTS,

---

What is the Difference between Procedure and Function.Can we call a Function in a DML?

2 Answers   TCS,

---

What are the modes of parameters that can be passed to a procedure ?

3 Answers  

---