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
- 9575 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 a subquery in sql?
What is procedure explain with program?
What are few of the schema objects that are created using PL/SQL?
Why do we need pl sql?
what is a tablespace? : Sql dba
Is pl sql still used?
Is big data nosql?
How to make a copy values from one column to another in sql?
Do prepared statements prevent sql injection?
Can we use ddl commands in pl sql?
What is pl sql in dbms?
Why having clause is used in sql?
What is scalar data type in pl sql?
Enlist the advantages of sql.
Can we rollback after truncate?
