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
- 9774 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 difference between database trigger and stored procedure?
What does inner join mean?
Give the order of sql select?
how to check server status with 'mysqladmin'? : Sql dba
What are different types of functions in sql?
Which command is used to call a stored procedure?
What is clause in sql?
How to avoid using cursors?
define sql update statement ? : Sql dba
Where is pl sql used?
how are mysql timestamps seen to a user? : Sql dba
how mysql optimizes distinct? : Sql dba
Explain the components of sql?
What is count * in sql?
What is auto increment?
