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
- 7775 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
What is trigger types in sql?
Is stored procedure faster than query?
What is sharding in sql?
What is trigger in sql? Explain
explain the difference between myisam static and myisam dynamic. : Sql dba
What are the different types of functions in sql?
Does group by remove duplicates?
What are few of the schema objects that are created using PL/SQL?
Explain what is a view?
How do I run a pl sql procedure in sql developer?
What is difference between rank () row_number () and dense_rank () in sql?
Is sql harder than python?
What is sqlite format?
Can sql function call stored procedure?
what is the difference between clustered and non clustered index in sql? : Sql dba
