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 / 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
How many sectors are in a partition?
Explain correlated query work?
What is sql rowcount?
What steps server process has to take to execute an update statement?
how can we find the number of rows in a table using mysql? : Sql dba
What does partition by mean in sql?
What is data definition language?
Can cursors be part of a trigger body?
what is auto increment? : Sql dba
Is sql procedural language?
How do you delete duplicates in sql query using rowid?
What are secondary keys?
Do we need commit after truncate?
What do you understand by case manipulation functions?
What are the types of triggers in sql?