sales persons should always receive commission of 100 at
least. employees who r not sales persons should never
receive commission.(Triggers)
- 1 Answers
- 7894 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 do you run a query?
The select into statement is most often used to create backup copies of tables or for archiving records?
How does a covering index work?
what is a tablespace? : Sql dba
What is scalar function in sql?
How to use sql statements in pl/sql?
What is type and rowtype in pl sql?
What is sqlca in powerbuilder?
how can we submit a form without a submit button? : Sql dba
Can we call a function containing dml statements in a select query?
Show how functions and procedures are called in a pl/sql block.
What is a variable in sql?
what are the 'mysql' command line options? : Sql dba
What are pl/sql cursors?
How do I make sql search faster?
