What is the main difference between sql and pl/sql?

0 Answers  

---

i declare 4 procedure in package specification but in package body i write only 3 procedure. is it complie??//w

4 Answers   Scope International,

---

How to run sql functions in pl/sql?

0 Answers  

---

Why are sql stored procedures used?

0 Answers  

---

What is nosql vs sql?

0 Answers  

---

What is auto increment in sql?

0 Answers  

---

Explain how exception handling is done in advance 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,

---

Can a composite key be null?

0 Answers  

---

how to debugg a procedure or package using dbms_output.put_line in plsql

1 Answers   Polaris,

---

What is group function in sql?

0 Answers  

---

how to analyze tables with 'mysqlcheck'? : Sql dba

0 Answers  

---