Interested to Buy Any Domain ? << Click Here >> for more details...
sales persons should always receive commission of 100 at
least. employees who r not sales persons should never
receive commission.(Triggers)
- 1 Answers
- 8258 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
Why we use stored procedure instead of query?
Is sql a case sensitive language?
what is a tablespace? : Sql dba
What are user defined functions?
What is the primary key?
What is multiple columns?
Is left join same as inner join?
What is trigger types of trigger?
When are we going to use truncate and delete?
Is sql a microsoft product?
how to install mysql? : Sql dba
What is restrict in sql?
What is nosql example?
How do I find duplicates in the same column?
What is a sql profiler?
