create or replace trigger trigger_name before update on emp for each ro

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

Question Posted / narenkumar reddy

1 Answers
8338 Views
Fidelity, Oracle, I also Faced
E-Mail Answers

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

What is execution plan in sql?

1052

What port does sql server use?

1065

Which function is used to return remainder in a division operator in sql?

1144

Is sql dba a good career? : SQL DBA

996

What is trigger explain it?

1019

how to convert character strings to dates? : Sql dba

1065

What is the difference between the sql*loader and import utilities? : aql loader

1044

Is pl sql different from sql?

1002

What is the use of <> sql?

980

What is not in sql?

952

Is primary key clustered or nonclustered?

1021

How do I save a stored procedure?

1011

How insert into statements in sql?

1080

What is the purpose of a sql?

977

How do I view a procedure in sql?

978