Answer Posted / 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 a rank in sql?

1004

---

What is mutating trigger?

1071

---

Can variables be used in sql statements?

1073

---

How do we accept inputs from user during runtime?

1116

---

In a distributed database system, can we execute two queries simultaneously?

1152

---

What is sql trigger example?

1113

---

How do I install microsoft sql?

1112

---

What are the 3 modes of parameter?

1203

---

how to return query output in html format? : Sql dba

1120

---

what is the bond code in materialized view?

3057

---

How do I enable sql encryption?

1069

---

What is cross join sql?

962

---

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4458

---

What is character functions?

1114

---

What is AUTH_ID and AUTH_USER in pl/sql ?

2231

---