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
- 7759 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
Explain what is a subquery ?
how to use regular expression in pattern match conditions? : Sql dba
How to run sql statements with oracle sql developer?
How do I audit the sql sent to the server?
What are tables and fields in the database?
How do sql databases work?
what is the stuff function and how does it differ from the replace function? : Sql dba
What is the sql case statement?
What is data abstraction in sql?
What is sql*loader?
How will you distinguish a global variable with a local variable in pl/sql?
What is the use of <> sql?
What is difference between pl and sql?
What is procedure explain with program?
How to fetch alternate records from a table?
