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
- 9527 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
What is the use of sql trace?
What are the rules to be applied to nulls whilst doing comparisons?
What is the life of an sql statement?
Is progress software supports to ( pl/sql )?
Can we edit a view in sql?
What is difference between group by and partition by?
What is the command used to fetch first 5 characters of the string?
How do I install sql?
Is it possible for a table to have more than one foreign key?
Describe different types of general function used in sql?
Compare sql & pl/sql
what is isam? : Sql dba
What is scope and visibility in PL/SQL?
What is the difference between clustered and non-clustered indexes?
How do you modify a trigger?
