What is pls integer?

0 Answers  

---

Is sql sequential or random?

0 Answers  

---

What are the advantages of stored procedure?

0 Answers  

---

How are sql commands classified?

0 Answers  

---

Write a sql query to find the names of employees that begin with ‘a’?

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,

---

In packages the source code is compiled into p code ? how do we describe the p code

3 Answers  

---

How do you use join?

0 Answers  

---

Is it mandatory for the primary key to be given a value when a new record is inserted?

0 Answers  

---

What is blind sql injection?

0 Answers  

---

Is pl sql useful?

0 Answers  

---

List out the acid properties and explain?

0 Answers  

---