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
- 8630 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 crud stand for?
Is sql sequential or random?
What are synonyms in sql?
How many databases can sql express handle?
How can you know that statistics should be updated?
What is recursive stored procedure?
What is fmtonly in sql?
What is the file extension for sql database?
What do you understand by pl/sql packages?
What is pl sql commands?
What is the use of triggers?
How do I save the results of sql query in a file?
What are the different schemas objects that can be created using pl/sql?
What are the types of optimization?
Does execute immediate commit?
