Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9346 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / swastik
declare
v_deptno number(2) := &gdeptno;
v_dname varchar2(20);
v_ename varchar2(20);
begin
select deptno, dname, ename into v_deptno, v_dname, v_ename
from dept
where deptno = v_deptno;
dbms_output.put_line(v_deptno|| ' '||v_dname||' '||v_ename);
exception
when no_data_found
then
dbms_output.put_line('record was not found');
end;
/
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is offset and limit in sql?
What is the sql*loader? : aql loader
What is a record in pl/sql?
Explain the difference between 'between' & 'and' operators in sql
Can two tables have same primary key?
What are different categories of sql commands?
What are the different dcl commands in sql?
How do you update a sql procedure?
Does varchar need length?
Show how functions and procedures are called in a pl/sql block.
Which operator is used in query for pattern matching?
what are local and global variables and their differences? : Sql dba
How many types of triggers are there in pl sql?
How bulk collect improves performance?
What is the requirement of self-join?
