What is the difference between numeric and autonumber?

0 Answers  

---

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

0 Answers  

---

Define union, minus, union all, intersect ?

0 Answers  

---

What is foreign key and example?

0 Answers  

---

Can you have multiple SPs with the same name on a database?

6 Answers   CGI,

---

What is union and union all keyword in sql?

0 Answers  

---

How do you go back in sql?

0 Answers  

---

What is trigger with example?

0 Answers  

---

What is over () in sql?

0 Answers  

---

What does (*) mean in 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 difference between triggers and stored procedures. And advantages of SP over triggers ?

4 Answers   Microsoft, TCS,

---