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

Is primary key an index?

983

How do I partition in sql?

942

How many sql commands are there?

1102

Can we rollback after truncate?

1012

How do you go back in sql?

973

what is msql? : Sql dba

967

What is a constraint?

997

What is sqlcommand?

1006

What is the maximum database size for sql express?

1007

What is serial sql?

954

What are the different types of a subquery?

1031

What is sql dialect?

1093

What are the types of sql commands?

1072

what are aggregate and scalar functions? : Sql dba

1036

How does index help in query performance?

1013