Answer / kishore

yes........

create or replace trigger emp_biu
before insert or update on employee
referencing new as new old as old
for each row
begin
if nvl(:new.salary,0) >= 10000 then
raise_application_error (-20999,'Salary with
commissions should be less than 10000');
end if;
end;
/

What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..

1 Answers   Metric Stream, Polaris,

---

What is difference between rank () row_number () and dense_rank () in sql?

0 Answers  

---

What are Anti joins

1 Answers   IBM,

---

Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.

4 Answers   Cap Gemini, IBM,

---

What is delimiter sql?

0 Answers  

---

Is inner join same as self join?

0 Answers  

---

How packaged procedures and functions are called from the following?

2 Answers  

---

Could you please provide oca (oracle 10g) dumps for my certification ?

1 Answers  

---

Can we rollback after truncate?

0 Answers  

---

what is the command used to fetch first 5 characters of the string? : Sql dba

0 Answers  

---

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

0 Answers  

---

Is it possible to include an insert statement on the same table to which the trigger is assigned?

0 Answers  

---