What is the default isolation level in sql server? : Transact sql

0 Answers  

---

How do you get column names only for a table (sql server)?

0 Answers  

---

What is the difference between syntax error and runtime error?

0 Answers  

---

Why do we use %rowtype & %type in plsql?

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,

---

How delete all data from all tables in sql?

0 Answers  

---

how is myisam table stored? : Sql dba

0 Answers  

---

Which are sql * plus commands?

0 Answers  

---

Write a simple program on cursors

2 Answers   BirlaSoft,

---

What is the difference between rollback and rollback to statements?

0 Answers  

---

Where not exists in sql?

0 Answers  

---

How many aggregate functions are available there in sql?

0 Answers  

---