What are the usages of sql?

0 Answers  

---

Is sql a scripting language?

0 Answers  

---

what tools available for managing mysql server? : Sql dba

0 Answers  

---

what is the use of set statement in tsql? : Transact sql

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 the usage of NVL?

7 Answers   Infosys, Micro Infotek,

---

Explain about various levels of constraint.

0 Answers  

---

What are the sql versions?

0 Answers  

---

How would you reference column values before and after you have inserted and deleted triggers?

0 Answers  

---

What is the best strategy to use COMMIT in a pl/sql loop?

3 Answers  

---

What is meant by truncate in sql?

0 Answers  

---

What is TABLE SPACE?

4 Answers   ABB, TCS,

---