discuss about myisam key cache. : Sql dba

0 Answers  

---

Is sql better than access?

0 Answers  

---

Are sql database names case sensitive?

0 Answers  

---

how many ways to get the current time? : Sql dba

0 Answers  

---

what is explain plan?, given an example...

3 Answers   Polaris,

---

what is the difference between a having clause and a where clause? : 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,

---

Define select, insert, create, delete, update, drop keywords

0 Answers  

---

What is group function in sql?

0 Answers  

---

what is External tables? explain with examples

2 Answers   TCS,

---

How can we make an if statement within a select statement?

0 Answers  

---

what is heap table? : Sql dba

0 Answers  

---