wtite down triggr not any entry on Sunday

2 Answers   NIT,

---

What is lookup table in sql?

0 Answers  

---

What is the default isolation level in sql server? : 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 a pragma statement?

0 Answers  

---

Does execute immediate commit?

0 Answers  

---

what is the difference between undefined value and null value? : Sql dba

0 Answers  

---

How is data stored on a disk?

0 Answers  

---

How do you rename a table in sql?

0 Answers  

---

What is rank () in sql?

0 Answers  

---

How can we avoid duplicating records in a query?

0 Answers  

---

What is dense_rank?

0 Answers  

---