How can I see all tables in sql?

0 Answers  

---

What is nosql example?

0 Answers  

---

Why truncate is used in sql?

0 Answers  

---

What are inner and outer joins examples of both?

0 Answers  

---

What is the use of nvl function?

0 Answers  

---

How does sql profiler work?

0 Answers  

---

declare v_count number(8,3); v_sal scott.emp.sal%type := '&P_sal'; cursor cur_name is select sal from scott.emp where sal between (v_sal-100) and (v_sal +1000); begin v_count :=nvl(sql%rowcount ,0); if v_count = 0 then dbms_output.put_line('no records are fetch in the given sal range'); else dbms_output.put_line('There is/are '||to_char(v_count)|| ' salaries are selected in the given range '); end if; end; in the above programm .....for any sal range ....always it shows the following message.. no records are fetch in the given sal range please find the mistake and share with me...with thansk and regards..sarao....

3 Answers   Satyam,

---

what is acid property in database? : Sql dba

0 Answers  

---

Which certification is best for sql?

0 Answers  

---

Why is sql important?

0 Answers  

---

what is bcp? When is it used?

0 Answers  

---

Compare sql & pl/sql

0 Answers  

---