Answer / highness

good,



isn't it possible by using :new pseudo records within
a trigger???

Answer / swapna

First create a Trigger and with Procedure you insert
records.
The :new will take the new values.
So use Triggers in Procedures.

What is difference sql and mysql?

0 Answers  

---

What is pl/sql tables?

7 Answers   TCS,

---

What is the difference between an inner join and an outer join?

0 Answers  

---

What is procedure in pl sql?

0 Answers  

---

What is pl sql in oracle?

0 Answers  

---

Whate is use of MOD function in pl/sql.

3 Answers   Oracle,

---

i want run a sql query query? which phases are run in a back ground? pls tell me the answer

1 Answers  

---

Explain the working of foreign key?

0 Answers  

---

Do we need commit after truncate?

0 Answers  

---

How do I trace sql profiler?

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 different categories of sql commands?

0 Answers  

---