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.
- 5 Answers
- 7777 Views
- Wipro, I also Faced
- E-Mail Answers
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
Is drop table faster than truncate?
What are hotfixes and patches?
what's the difference between a primary key and a unique key? : Sql dba
What is substitution variable?
Is postgresql a nosql database?
What are the indexing methods?
Which sorts rows in sql?
What is a primary key called that is made up of more than one field?
What is coalesce sql?
What is sqlca in powerbuilder?
What are variables in pl sql?
who introduced sql?
What is the difference between function and procedure in pl/sql?
what are the 'mysql' command line arguments? : Sql dba
Where can I learn sql for free?
