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
9611 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

What are different types of sql commands?

1128

Can we write dml inside a function in sql server?

964

What does count (*) do in sql?

1020

What are the sql commands?

1189

Why do we need databases?

1055

Is left join inner or outer?

1028

What is on delete set null?

1096

Is a foreign key always unique?

950

How to display the records between two range in Oracle SQL Plus?

1156

Mention what are the benefits of pl/sql packages?

1090

How many developers work on postgresql?

989

What is meant by cursor in sql?

1007

What is the difference between rollback and rollback to statements?

1066

What is a stored procedure in sql with example?

1139

What is numeric function sql?

1070