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


Please Help Members By Posting Answers For Below Questions

What packages are available to pl/sql developers?

597


What are types of joins?

532


What is dba in sql? : SQL DBA

529


How to fetch alternate records from a table?

675


What is the command used to fetch the first 5 characters of a string?

704






what are all the different types of indexes? : Sql dba

526


What is the need of merge statement?

550


Which certification is best for sql?

534


What is sql comments?

648


Compare sql & pl/sql

602


when MSQL8.0 is in market

1594


What is localdb mssqllocaldb?

613


What does the argument [or replace] do?

577


Is postgresql a server?

573


What are the benefits of pl sql?

523