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 / dmddebasismohanty183
Please Send Me The Answer
Thanks And Regards
Debasis Mohanty
dmdebasismohanty183@gmail.com
Contact:08722140827
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
Explain aggregate functions are available there in sql?
What is the difference between left and left outer join?
What is the difference between clustered and non-clustered indexes?
What is the difference between Union and Union all. Which is faster.
How to write a query to show the details of a student from students table whose
What is sql keyword?
How do I start sql profiler?
What is synonyms?
How to get help at the sql prompt?
What is the difference between nvl function, ifnull function, and isnull function?
What is the difference between python and sql?
Is there any restriction on the use of union in embedded sql?
Is join same as left join?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins