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 unique keys be null?

0 Answers  

---

How can I change database name in sql?

0 Answers  

---

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

0 Answers   CTS,

---

Which is better stored procedure or query?

0 Answers  

---

What is error ora-12154: tns:could not resolve the connect identifier specified?

0 Answers  

---

what is 'mysqlshow'? : Sql dba

0 Answers  

---

Is it possible to link two groups inside a cross products after the cross products group has been created?

0 Answers  

---

Does truncate require commit?

0 Answers  

---

How you improve the performance of sql*loader? : aql loader

0 Answers  

---

How do rank () and dense_rank () differ?

0 Answers  

---

How can we overcome recursive triggers in SQL?

1 Answers   iFlex,

---

ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.

2 Answers  

---