How many sql statements are used? Define them.

0 Answers  

---

how do you control the max size of a heap table? : Sql dba

0 Answers  

---

write an sql query to find names of employee start with 'a'? : Sql dba

0 Answers  

---

what is commit? : Sql dba

0 Answers  

---

Why use stored procedures?

0 Answers  

---

what is bulk bind

4 Answers   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,

---

Can I call a procedure inside a function?

0 Answers  

---

How can we store rows in PL/SQL using array?

0 Answers   MCN Solutions,

---

What is sql keyword?

0 Answers  

---

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

0 Answers  

---

What is PL/SQL Records?

0 Answers  

---