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 is the difference between delete and truncate commands?

0 Answers  

---

How do you declare a user-defined exception?

0 Answers  

---

What are Lexical Parameters.How They are used in Reports 6i

2 Answers   eicc,

---

What is a delimiter in sas?

0 Answers  

---

What is difference between primary and secondary key?

0 Answers  

---

What information is needed to connect sql*plus an oracle server?

0 Answers  

---

What is rank dense_rank and partition in sql?

0 Answers  

---

how to drop an existing view in mysql? : Sql dba

0 Answers  

---

List out the acid properties and explain?

0 Answers  

---

Why stored procedures are faster than query?

0 Answers  

---

Can we write ddl statements in functions?

0 Answers  

---

How to handle bulk data?

0 Answers  

---