package specification-3 procedures package body-4 procedures how can i write for other procedure in package body

2 Answers   Reliance,

---

what are the authentication modes in sql server? How can it be changed? : Sql dba

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,

---

how to concatenate two character strings? : Sql dba

0 Answers  

---

i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example empno ename mgr_id 1 john 3 2 paul 3 3 smith 1 4 kevin 1 5 stewart 2 result has to look like this ename manager john smith paul smith smith john kevin john stewart paul can u plz help me out in this.....

8 Answers  

---

What is the difference between functions, procedures, and packages in pl/sql?

0 Answers  

---

Explain what is a column in a table?

0 Answers  

---

What is the difference between count 1 and count (*) in a sql query?

0 Answers  

---

What is offset in sql query?

0 Answers  

---

can sql servers linked to other servers like oracle? : Sql dba

0 Answers  

---

how can we destroy the cookie? : Sql dba

0 Answers  

---

Which one of the following join types will always create a Cartesian Product? 1. CROSS JOIN 2. LEFT OUTER JOIN 3. RIGHT OUTER JOIN 4. FULL OUTER JOIN 5. INNER JOIN

2 Answers  

---