Answer / guest

declare
khali exception;
a number(8);
b number(8);
begin
select count(*) into b from &table_name;
dbms_output.put_line('value of b is '||b);
if b = 0 then
raise khali;
end if;
exception
when khali then
dbms_output.put_line('are ye table to khali
nikali');
when others then
select NUM into a from furzi2;
dbms_output.put_line('Others');
end;
/

what are the advantages of package?

7 Answers   iFlex,

---

Can we use update in sql function?

0 Answers  

---

what is a constraint? Tell me about its various levels. : Sql dba

0 Answers  

---

Can you selectively load only those records that you need? : aql loader

0 Answers  

---

what are all the common sql function? : Sql dba

0 Answers  

---

Explain polymorphism in pl/sql.

0 Answers  

---

How to add, remove, modify users using sql?

0 Answers  

---

Is natural join same as inner join?

0 Answers  

---

explain about mysql and its features. : Sql dba

0 Answers  

---

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

0 Answers  

---

what is a constraint? : Sql dba

0 Answers  

---

Name the different types of indexes in sql and define them.

0 Answers  

---