Explain the PL/SQL compilation process.

3 Answers  

---

what is the sql query to display current date? : Sql dba

1 Answers  

---

What language is oracle sql developer?

0 Answers  

---

what is a cursor? : Sql dba

0 Answers  

---

What is normalization in a database?

0 Answers  

---

Types of joins?

4 Answers   Microsoft,

---

define sql delete statement ? : Sql dba

0 Answers  

---

Are stored procedures faster than dynamic 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,

---

what are the security recommendations while using mysql? : Sql dba

0 Answers  

---

What is write ahead logging in sql server?

0 Answers  

---

Can a trigger call a stored procedure?

0 Answers  

---