sales persons should always receive commission of 100 at
least. employees who r not sales persons should never
receive commission.(Triggers)
- 1 Answers
- 7560 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
How to change sql*plus system settings?
Is primary key clustered or nonclustered?
Which is better join or subquery?
what are the properties and different types of sub-queries? : Sql dba
What are tables and fields?
What is an example of translating a date into julian format?
how to create a test table in your mysql server? : Sql dba
How show all rows in sql?
What is a subquery in sql?
Which type of cursor is used to execute the dml statement?
Which join is default?
Is stored procedure faster than query?
I need a function for a train ticket reservation please answer it thanks in advance
what is index? : Sql dba
Is truncate ddl or dml?
