1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

sales persons should always receive commission of 100 at
least. employees who r not sales persons should never
receive commission.(Triggers)

Question Posted / radha


sales persons should always receive commission of 100 at least. employees who r not sales persons ..

Answer / narenkumar reddy

create or replace
trigger trigger_name
before update on emp
for each row
begin
if job<>'salesman' then
raise_application_error(-20001,'should never receive the
commission')
end if;
end;

Is This Answer Correct ?    6 Yes 13 No

Post New Answer

More SQL PLSQL Interview Questions

How many commands are there in sql?

0 Answers  

What are dml commands?

0 Answers  

What is trigger in sql? Explain

0 Answers  

What are triggers and its uses?

0 Answers  

Easy way to convert tableau "IF - ELSEIF" statements to Netezza "CASE" statements.

1 Answers   CTS,




What are the steps for performance tuning.

0 Answers  

Can we join 3 tables in sql?

0 Answers  

In a package if we have 10 procedures or functions,How to know which will execute first?

1 Answers   Sollet Soft,

what are aggregate and scalar functions? : Sql dba

0 Answers  

What is a database trigger ? Name some usages of database trigger ?

4 Answers  

What are expressions?

0 Answers  

What do you mean by table in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories