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.
Answer Posted / 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 |
Post New Answer View All Answers
what is the difference between $message and $$message? : Sql dba
What is embedded sql what are its advantages?
What are hotfixes and patches?
What is the location of pre_defined_functions.
What is Histogram?
how are mysql timestamps seen to a user? : Sql dba
What is a left inner join?
What is an intersect?
What is memory optimized table?
What is normalization in sql?
What is trigger in sql?
What is the difference between microsoft access and sql server?
what are the drivers in mysql? : Sql dba
Explain cursor types?
What is trigger with example?