If That dept 30 contains more than 1 employee then your answer is wrong er

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.

Question Posted / debasis mohanty

5 Answers
9595 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / debasis mohanty

If That dept 30 contains more than 1 employee then your answer is wrong
erorr:exact fetch returns more than 1 rows

Is This Answer Correct ?

3 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Define overloaded procedure?

1081

how many values can the set function of mysql take? : Sql dba

987

what is 'mysqlcheck'? : Sql dba

1015

Does sql*plus also have a pl/sql engine?

1082

List the ways to get the count of records in a table?

900

Should I use mbr or gpt?

1026

How is use pl and sql?

1063

What is a primary key called that is made up of more than one field?

1351

How does postgresql compare to "nosql"?

1031

How to select unique records from a table?

1059

What does where 1 1 mean in sql?

1043

what is sql server agent? : Sql dba

1109

How do you pronounce sql?

1013

what are date and time data types in mysql? : Sql dba

971

what is an index? : Sql dba

997