What are sql queries used for?

0 Answers  

---

What is a table in a database?

0 Answers  

---

How do you go back in sql?

0 Answers  

---

What is before trigger?

0 Answers  

---

What is self-join and what is the requirement of self-join?

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,

---

I have 2 Databases. How can create a table in particular database? How can i know the list of tables presented each database?( in oracle 10g)

5 Answers   Relq,

---

display null value rows with out using null function?

8 Answers   Infosys,

---

Name Salary Abc 50000 Abc 50000 xyz 20000 find the max salary using aggregate function?

2 Answers   CTS,

---

What is mutating error in pl sql?

0 Answers  

---

what is organisational index?

1 Answers  

---

Can we insert in sql function?

0 Answers  

---