Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9354 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 sql between inclusive?
Define implicit and explicit cursors.
how to use like conditions? : Sql dba
What is pl sql collection?
What is the difference between inner join and outer join?
Name the operator which is used in the query for pattern matching?
give the syntax of grant and revoke commands? : Sql dba
What is pl sql code?
How to revise and re-run the last sql command?
What is sql profiler in oracle?
Why use triggers in sql?
What is a mutating table and a constraining table?
Does group by remove duplicates?
What is output spooling in sql*plus?
What are the topics in pl sql?
