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

Can you have a foreign key without a primary key?

0 Answers  

---

How do you bind variables in pl sql?

0 Answers  

---

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

0 Answers  

---

how will be date change into string

4 Answers  

---

How global cursor can be declare with dynamic trigger ?

0 Answers  

---

what is top in tsql? : Transact sql

0 Answers  

---

Is postgresql a nosql database?

0 Answers  

---

what is explain plan?, given an example...

3 Answers   Polaris,

---

What is meant by user defined function?

0 Answers  

---

what is data integrity

3 Answers   Fidelity, TCS,

---

1> how are u debugging in plsql ? 2> how to connect oracle database from unix. is there ne way other than using sqlplus ?

2 Answers  

---

Can you sum a count in sql?

0 Answers  

---