how to increment dates by 1 in mysql? : Sql dba

0 Answers  

---

what is error ora-03113: end-of-file on communication channel?

0 Answers  

---

Explain the rollback statement?

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,

---

How can we make an if statement within a select statement?

0 Answers  

---

Explain the significance of the & and && operators in pl sql.

0 Answers  

---

what is the difference between truncate and drop statements? : Sql dba

0 Answers  

---

What is vector point function?

0 Answers  

---

how tsql statements can be written and submitted to the database engine? : Transact sql

0 Answers  

---

Can variables be used in sql statements?

0 Answers  

---

What are triggers in sql?

0 Answers  

---

Is sql scripting language?

0 Answers  

---