1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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 / dmddebasismohanty183

Answers were Sorted based on User's Feedback



Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no rec..

Answer / vikas gupta

Declare
l_deptname dept.deptname%Type;
l_ename dept.ename%type;
Begin
select deptname,ename
into l_deptname,l_ename
from dept
where dept_no = 30;

if sql%notfound then
dbms_output.put_line("Record was not Found")
else
dbms_output.put_line("Deptname=" l_deptname);
dbms_output.put_line("Ename=" l_ename);
end if;

end;

Is This Answer Correct ?    10 Yes 8 No

Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no rec..

Answer / debasis mohanty

If That dept 30 contains more than 1 employee then your answer is wrong
erorr:exact fetch returns more than 1 rows

Is This Answer Correct ?    3 Yes 1 No

Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no rec..

Answer / swastik

declare
v_deptno number(2) := &gdeptno;
v_dname varchar2(20);
v_ename   varchar2(20);
begin
select deptno, dname, ename into v_deptno, v_dname, v_ename 
from dept
where deptno = v_deptno;
dbms_output.put_line(v_deptno|| ' '||v_dname||' '||v_ename);
exception
when no_data_found
then
dbms_output.put_line('record was not found');
end;
/

Is This Answer Correct ?    2 Yes 0 No

Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no rec..

Answer / dmddebasismohanty183

Please Send Me The Answer





Thanks And Regards
Debasis Mohanty
dmdebasismohanty183@gmail.com
Contact:08722140827

Is This Answer Correct ?    0 Yes 0 No

Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no rec..

Answer / 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

More SQL PLSQL Interview Questions

Is sqlite good enough for production?

0 Answers  

there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?

12 Answers   Oracle,

What are the different operators available in sql?

0 Answers  

I Defined SP1, Sp2 (sp=StoreProcedures)In Package Specification but I Implemented Sp1, sp2, sp3, sp4, sp5 then What type of Error You will find????

3 Answers   Infosys,

What are the different sql languages?

0 Answers  




What is raw datatype in sql?

0 Answers  

How many null values can be inserted in a coulmn whihc is unique constraint

8 Answers   Flextronics,

explain advantages of myisam over innodb? : Sql dba

0 Answers  

what is the use of friend function? : Sql dba

0 Answers  

List out the acid properties and explain?

0 Answers  

Is sql a programming?

0 Answers  

What is implicit cursor in pl sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories