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
- 9574 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / xyz
declare
cursor mycursor is
select dname,ename from emp ,dept where emp.deptno=dept.deptno and dept.deptno=30;
v_dname dept.dname%type;
v_ename emp.ename%type;
begin
open mycursor;
loop
exit when mycursor%notfound;
fetch mycursor into v_dname,v_ename;
exception
when no_data_found then
dbms_output.put_line(v_dname||' '||v_ename);
end loop;
close mycursor;
end;
| Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
what is sql profiler? : Sql dba
What do you mean by query optimization?
What is sql entity?
explain what is mysql? : Sql dba
What is the difference among union, minus and intersect?
differentiate between float and double. : Sql dba
What is sql partition?
What is mdb stand for?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
What is normalisation and its types?
What is primary key in db?
What is the benefit of foreign key?
What type of database is sql?
How do I remove sql plus from windows 10?
Do we need to rebuild index after truncate?
