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 delete command in sql?

0 Answers  

---

What are the differences between implicit and explicit cursors?

0 Answers  

---

How collections are improve the performance?

1 Answers   Polaris,

---

Types of cursor locks and explanation each of them ?

3 Answers   DELL, HP Finsoft,

---

What is keys and its types?

0 Answers  

---

How do you add a column to a table?

0 Answers  

---

Do ddl statements need commit?

0 Answers  

---

What operators deal with null?

0 Answers  

---

what is difference between "Primary key" and "Unique key"?

4 Answers   PreVator,

---

How do you concatenate in sql?

0 Answers  

---

I m giving Source, Destination and Age. Write a procedure or function, it will give to u this source to destination tickets are available or not, if available then check this person is senior citizen or not,if this person is senior citizen then give some discount. PLZ give this answer...... Thanks advance.....

3 Answers  

---

Mention what is the function that is used to transfer a pl/sql table log to a database table?

0 Answers  

---