What does := mean in pl sql?

0 Answers  

---

What is gpt format?

0 Answers  

---

Is left join same as inner join?

0 Answers  

---

how can create data base link for tow servers (scott schema) give examples plz

2 Answers  

---

In a distributed database system, can we execute two queries simultaneously?

0 Answers  

---

Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --

5 Answers  

---

how to find 5th row ?

10 Answers  

---

What is a natural join sql?

0 Answers  

---

Why trigger is used in sql?

0 Answers  

---

How do I find duplicates in the same column?

0 Answers  

---

how would concatenate strings in mysql? : 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,

---