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
9593 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 sql*plus environment variables?

1094

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1209

How do I kill a query in postgresql?

1127

Can sql function call stored procedure?

1022

How does left join work in sql?

1002

what is the use of friend function? : Sql dba

1023

what is the difference between nested subquery and correlated subquery?

1054

What are the different types of triggers?

1136

Can we join two tables without common column?

1002

Which sql most popular?

989

What is the requirement of self-join?

1132

Is full outer join same as cross join?

969

What is an exception in pl/sql?

1088

Differentiate between pl/sql and sql?

1149

how to create a new table in mysql? : Sql dba

986