What will be the output for the below Query Select 'High' from dual where null = null;

12 Answers   Infosys, Satyam,

---

What is keys and its types?

0 Answers  

---

What is pl sql architecture?

0 Answers  

---

What is union and union all keyword in sql and what are their differences?

0 Answers  

---

Is t sql a programming language?

0 Answers  

---

What is compound trigger?

0 Answers  

---

What is the criteria while applying index to any column on any table.

1 Answers   Infogain,

---

Can primary key be changed?

0 Answers  

---

What is the fastest way of accessing a row in a table?

5 Answers   TCS,

---

How to create a view on a table which does not exists

4 Answers   Oracle, TCS,

---

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,

---

explain the delete statements in sql

0 Answers  

---