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

How do you declare a variable in pl sql?

0 Answers  

---

What does plv msg allows you to do?

0 Answers  

---

What is the basic structure of an sql?

0 Answers  

---

What is trigger types in sql?

0 Answers  

---

How to call a javascript function from pl sql?

0 Answers  

---

tell me about various levels of constraint. : Sql dba

0 Answers  

---

What does select top 1 do in sql?

0 Answers  

---

Why are indexes and views important to an organization?

0 Answers  

---

what is 'mysqldump'? : Sql dba

0 Answers  

---

Is pl sql better than sql?

0 Answers  

---

HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP

1 Answers   TCS,

---

what are the 'mysql' command line arguments? : Sql dba

0 Answers  

---