Answer / sadhana

conflict serialisability
view serialisability

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 are the data types allowed in a table?

3 Answers  

---

write a query find which rows of a table is updated on 2 days before?

3 Answers   TCS,

---

Difference between a query and strored procedure?

4 Answers   Microsoft,

---

How is debugging done?

0 Answers  

---

---

What is mutating table?

11 Answers   Saama Tech,

---

what is the need of the cursor attribute notfound..(because using found attribute we can complete the task......found + negation operator = not found )

2 Answers   Tech Mahindra,

---

What are the types of sql commands?

0 Answers  

---

what is the difference between $message and $$message? : Sql dba

0 Answers  

---

How many developers work on postgresql?

0 Answers  

---

What is example of database?

0 Answers  

---

Can we connect to postgresql using sql developer?

0 Answers  

---