Can we have exception part in trigger ?
Answer / kishore
yes........
create or replace trigger emp_biu
before insert or update on employee
referencing new as new old as old
for each row
begin
if nvl(:new.salary,0) >= 10000 then
raise_application_error (-20999,'Salary with
commissions should be less than 10000');
end if;
end;
/
| Is This Answer Correct ? | 15 Yes | 0 No |
what is the difference between implicit and explicit trigger
How do I view a sql database?
Its possible to add more than one primary key for the table
ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.
Can function return multiple values in sql?
Explain cursor types?
Can we connect to postgresql using sql developer?
What is the use of function "module procedure" in pl/sql?
What is the difference between microsoft access and sql?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
what are the types of subquery? : Sql dba
What is aggregate function in 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)