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

what are myisam tables? : Sql dba

951

What are different types of indexes?

958

What is an emotional trigger?

930

Explain isolation levels. : Transact sql

1014

how can we know the count/number of elements of an array? : Sql dba

1004

Can we connect to postgresql using sql developer?

934

What is substitution variable?

1001

What is the usage of the distinct keyword?

1166

What program will open a mdb file?

910

What is the difference between jpql and sql?

1022

What type of database is cloud sql?

1044

What is the main reason behind using an index?

965

explain the difference between bool, tinyint and bit. : Sql dba

937

What is #table in sql?

995

what is the difference between inner and outer join? Explain with example. : Sql dba

971