Answer / kiran r

Merge is an important SQL Statement that allows us to perform Insert, Update, Delete all at a time with out having to write separate logic. we can specify on which we need to perform merge.

How to come back in normal stage in Mutating Table if mutating table is locked or update data?

2 Answers  

---

Explain polymorphism in 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,

---

what are all types of user defined functions? : Sql dba

0 Answers  

---

How will you debug your procedure? If your procedure is around 2000 lines and the expected output is 10 and we get only output 5.So how will you debug it? Somebody pls give the correct answer?

2 Answers   Fidelity,

---

What is CYCLE/NO CYCLE in a Sequence?

2 Answers  

---

How do I restart sql?

0 Answers  

---

What is the difference between an inner and outer join?

0 Answers  

---

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

0 Answers  

---

What is difference between inner join and self join?

0 Answers  

---

what is d diff between grant,commit,rollback n savepoint

1 Answers  

---

Is pl sql useful?

0 Answers  

---