Answer / vikas gupta

Declare
l_deptname dept.deptname%Type;
l_ename dept.ename%type;
Begin
select deptname,ename
into l_deptname,l_ename
from dept
where dept_no = 30;

if sql%notfound then
dbms_output.put_line("Record was not Found")
else
dbms_output.put_line("Deptname=" l_deptname);
dbms_output.put_line("Ename=" l_ename);
end if;

end;

Answer / debasis mohanty

If That dept 30 contains more than 1 employee then your answer is wrong
erorr:exact fetch returns more than 1 rows

Answer / 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;
/

Answer / dmddebasismohanty183

Please Send Me The Answer





Thanks And Regards
Debasis Mohanty
dmdebasismohanty183@gmail.com
Contact:08722140827

Answer / xyz

declare
cursor mycursor is
select dname,ename from emp ,dept where emp.deptno=dept.deptno and dept.deptno=30;
v_dname dept.dname%type;
v_ename emp.ename%type;
begin
open mycursor;
loop
exit when mycursor%notfound;
fetch mycursor into v_dname,v_ename;
exception
when no_data_found then
dbms_output.put_line(v_dname||' '||v_ename);
end loop;
close mycursor;
end;

How is pl sql different from sql?

0 Answers  

How can I see all tables in sql?

0 Answers  

What is the use of pl/sql table?

0 Answers  

List different type of expressions with the example.

0 Answers  

I need a exceptoin in pl/sql block so that if any errors occur in the block then no exception should errors should raise?

1 Answers  

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

0 Answers  

Which is better cte or subquery?

0 Answers  

HOW TO PRINT * ** *** **** ***** BY USING SQL QUERY? (MAY BE USING SCRIPT)

8 Answers   BeBo Technologies,

List out the acid properties and explain?

0 Answers  

Why do we need cursors in pl sql?

0 Answers  

How can I speed up sql query?

0 Answers  

What are all the difference between Like and Contains ?

2 Answers   LG Soft,