What are tables and fields in the database?

0 Answers  

---

What is a database event trigger?

0 Answers  

---

what's the difference between a primary key and a unique key? : Sql dba

0 Answers  

---

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

0 Answers  

---

Explain how can you save or place your msg in a table?

0 Answers  

---

What does t sql mean?

0 Answers  

---

How is a process of pl/sql compiled?

0 Answers  

---

What is execute immediate?

0 Answers  

---

What is a function in oracle pl 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,

---

How to process query result in pl/sql?

0 Answers  

---

write a query to find out the no. of employees whose age is less than 25 and max of salary for the employees belonging to a particular department is less than 20000

6 Answers  

---