What is sql integrity?

0 Answers  

---

If records are inserted into table without committing.How to refer to these values in a procedure?

2 Answers  

---

What does an inner join do?

0 Answers  

---

what are the advantages of sql ? : Sql dba

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 are the advantages of the packages

6 Answers   Oracle,

---

what are the forced views

6 Answers   Hexaware, TCS,

---

How do I know if I have sql express or standard?

0 Answers  

---

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

0 Answers  

---

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

0 Answers  

---

difference between pl/sql table and normal pl/sql table

2 Answers  

---

What is INSTEAD OF trigger ?

13 Answers   Hexaware, TCS,

---