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
- 7760 Views
- Wipro, I also Faced
- E-Mail Answers
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
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
What is view explain with example?
What is compute?
What is dml and ddl?
How do you sort in sql?
Explain the insert into statements in sql?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What is a call statement? Explain with an example.
What does rownum mean in sql?
Is sql harder than python?
What are the three forms of normalization?
Explain table and field in sql?
Describe sql comments?
What is gpt format?
What is consistency?
