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.
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
Define overloaded procedure?
how many values can the set function of mysql take? : Sql dba
what is 'mysqlcheck'? : Sql dba
Does sql*plus also have a pl/sql engine?
List the ways to get the count of records in a table?
Should I use mbr or gpt?
How is use pl and sql?
What is a primary key called that is made up of more than one field?
How does postgresql compare to "nosql"?
How to select unique records from a table?
What does where 1 1 mean in sql?
what is sql server agent? : Sql dba
How do you pronounce sql?
what are date and time data types in mysql? : Sql dba
what is an index? : Sql dba