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
- 8625 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
give the syntax of grant and revoke commands? : Sql dba
What is the difference between left join and right join?
Why coalesce is used in sql?
What does over partition by mean in sql?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Explain the commit statement.
What are the datatypes available in pl/sql ?
Why select is used in sql?
What is a boolean in sql?
What is a Mapplet?
What are pl/sql cursors?
Which are sql * plus commands?
What is bulk collect in pl sql?
Do we need commit after truncate?
what is union? : Sql dba
