declare v_deptno number(2) := &gdeptno; v_dname varchar2(20); v

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.

Question Posted / swastik

5 Answers
9573 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

Please Help Members By Posting Answers For Below Questions

Give the order of sql select?

1133

What is the difference between having clause and where clause?

1057

How to execute a stored procedure?

1084

What is a system versioned table?

978

What is the difference between union and union all command?

1086

What is meant by user defined function?

1046

What is scalar and vector?

995

What is the purpose of cursors in pl/sql?

1134

What is cascade in sql?

961

Which is faster joins or subqueries?

986

how can we find the number of rows in a table using mysql? : Sql dba

1081

What is identity column in sql server?

1043

Is a secondary key the same as a foreign key?

1030

Can we use pl sql in mysql?

1009

What is pragma in pl sql?

1102