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
- 8271 Views
- Fidelity, Oracle, I also Faced
- E-Mail Answers
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 |
What is an oracle stored procedure?
Does truncate remove indexes?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
How to install oracle sql developer?
How can we make an if statement within a select statement?
What is the usage of distinct keyword?
explain the difference between bool, tinyint and bit. : Sql dba
what is the syntax used for partition in tsql? : Transact sql
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
What is before trigger?
What is sql select statement?
What is cross join sql?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
