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;

what is the different between unique+not null & primary key,

4 Answers  

---

What is a file delimiter?

0 Answers  

---

How to fetch records from a partitioned table?

2 Answers   HSBC,

---

Which one is better sql or oracle?

0 Answers  

---

In packages the source code is compiled into p code ? how do we describe the p code

3 Answers  

---

What are sql built in functions?

0 Answers  

---

what are the different type of normalization? : Sql dba

0 Answers  

---

Explain the usage of WHERE CURRENT OF clause in cursors ?

4 Answers   Satyam,

---

how to connect oracle in unix prompt?

4 Answers   Polaris,

---

What is database sql?

0 Answers  

---

How do I start sql from command line?

0 Answers  

---

Do ddl statements need commit?

0 Answers  

---