declare cursor mycursor is select dname,ename from emp ,dept where emp.de

Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.

Question Posted / xyz

5 Answers
9526 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / xyz

declare
cursor mycursor is
select dname,ename from emp ,dept where emp.deptno=dept.deptno and dept.deptno=30;
v_dname dept.dname%type;
v_ename emp.ename%type;
begin
open mycursor;
loop
exit when mycursor%notfound;
fetch mycursor into v_dname,v_ename;
exception
when no_data_found then
dbms_output.put_line(v_dname||' '||v_ename);
end loop;
close mycursor;
end;

Is This Answer Correct ?

2 Yes

6 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why do we use cursors?

976

what is a table in a database ? : Sql dba

1025

What has stored procedures in sql?

1047

What does the hierarchical profiler does?

1048

What is a unique key?

1035

What are transaction and its controls?

1022

What are expressions?

991

How does a self join work?

1080

What is trigger types of trigger?

1050

List the ways to get the count of records in a table?

894

What is the difference between explicit and implicit cursors in oracle?

1048

What are the benefits of triggers?

1160

Could you please provide oca (oracle 10g) dumps for my certification ?

5127

What does sql stand for?

976

Is record in oracle pl sql?

944