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
9538 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

How do I partition in sql?

950

What are different sql data types?

1022

Can we use insert statement in function?

986

how many ways we can we find the current date using mysql? : Sql dba

1081

How many sectors are in a partition?

1066

what is a stored procedure? : Sql dba

1113

Can we use threading in pl/sql?

1025

Can we use ddl statements in stored procedure?

1134

What is a sql select statement?

1028

Mention what is the plv (pl/vision) package offers?

1096

what is the command used to fetch first 5 characters of the string? : Sql dba

1629

What is output spooling in sql*plus?

1022

Does sap use sql?

968

What is nosql example?

1017

when MSQL8.0 is in market

2067