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 Complex index. how to create it?

2 Answers  

---

What is the purpose of cursors in pl/sql?

0 Answers  

---

What are all the different normalization?

0 Answers  

---

What are actual parameters and formal parameters?

0 Answers  

---

What do we need to check in database testing?

0 Answers  

---

Why we use sql profiler?

0 Answers  

---

what is oltp (online transaction processing)? : Sql dba

0 Answers  

---

Table name: T1, it has only one column. col1 ------ c b a b b b b d s a a t s Requirement: I need the following output from the above base table by using SQL query. col1 Cnt ----- ------- a 3 b 5 Others 5 Please help. Thanks Guru v.gurus@in.com

11 Answers  

---

Which query operators in sql is used for pattern matching?

0 Answers  

---

What are the types of SQL Statement?

3 Answers  

---

what is sql profiler

2 Answers   Fidelity,

---

What is bind reference and how can it be created?

0 Answers  

---