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
- 9570 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 pl sql script?
What is pl sql block structure?
What is the difference between a query and a report?
Is sql between inclusive?
What is trigger and stored procedure in sql?
What is the difference between inner join and outer join?
What trigger means?
What is use of package in pl sql?
What is difference between hql and sql?
Show how functions and procedures are called in a pl/sql block.
What is the order of sql select?
How many developers work on postgresql?
what are the authentication modes in sql server? : Sql dba
Is pl sql a scripting language?
What are the types of join and explain each?
