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
- 9621 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
How do we accept inputs from user during runtime?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
Explain correlated query work?
what is a relationship and what are they? : Sql dba
What are primary key and foreign key and how they work?
Is inner join faster than left join?
How many sql core licenses do I need?
How does stored procedure reduce network traffic?
What is an emotional trigger?
Is a view faster than a stored procedure?
What is normalisation in sql?
Can we use pl sql in mysql?
what is the syntax used for partition in tsql? : Transact sql
how to delete an existing column in a table? : Sql dba
where are cookies actually stored on the hard disk? : Sql dba
