What is an index in sql with example?

0 Answers  

---

What does where 1/2 mean in sql?

0 Answers  

---

What are the usage of SAVEPOINTS?

5 Answers  

---

What schema means?

0 Answers  

---

Which are the different types of indexes in sql?

0 Answers  

---

What is break?

0 Answers  

---

Why do we need pl sql?

0 Answers  

---

what is bulk bind

4 Answers   TCS,

---

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 do you identify a primary key?

0 Answers  

---

how to get enames with comma seperated values by deptwise on emp table?

8 Answers  

---

What is synchronized subquery?

0 Answers  

---