How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

0 Answers  

---

What is benefit of creating memory optimized table?

0 Answers  

---

Are null values same as that of zero or a blank space?

0 Answers  

---

What is a primary key called that is made up of more than one field?

0 Answers  

---

What is exit statement?

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,

---

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

0 Answers  

---

Is sql harder than python?

0 Answers  

---

What do you mean by stored procedures?

0 Answers  

---

what is the difference between blob and text? : Sql dba

0 Answers  

---

Explain what is an index?

0 Answers  

---

Can we call stored procedure in function?

0 Answers  

---