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
- 9766 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 does cross join work in sql?
What is file based approach?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
what are numeric data types? : Sql dba
What is data profiling in sql?
how to see the create table statement of an existing table? : Sql dba
What is set serveroutput on in pl sql?
What is coalesce in sql?
What plvcmt and plvrb does in pl/sql?
Is foreign key mandatory?
How to add, remove, modify users using sql?
Which are the different character-manipulation functions in sql?
What is cold data?
what does the t-sql command ident_current does? : Transact sql
Which join is default?
