what is the difference between trigger and constraint?

3 Answers   HSBC,

---

what is 'mysqlcheck'? : Sql dba

0 Answers  

---

Describe different types of general function used 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,

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

0 Answers   CTS,

---

---

How do you determine the current isolation level? : Transact sql

0 Answers  

---

How can you get sql*loader to commit only at the end of the load file? : aql loader

0 Answers  

---

What is the use of non clustered index?

0 Answers  

---

What do you think about pl/sql?

0 Answers  

---

what is top in tsql? : Transact sql

0 Answers  

---

Does a primary key have to be a number?

0 Answers  

---

What are the two different parts of the pl/sql packages?

0 Answers  

---