Answer Posted / 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 record in oracle pl sql?

940

---

What is a natural join?

1045

---

What is an inconsistent dependency?

1027

---

What do you understand by exception handling in pl/sql?

1011

---

how to add a new column to an existing table in mysql? : Sql dba

1047

---

What is percent sign in sql?

1260

---

Why do we use cursors?

974

---

Cite the differences between execution of triggers and stored procedures?

1071

---

What is cte sql?

971

---

What is numeric function sql?

1042

---

How do you write a subquery?

1002

---

what are date and time intervals? : Sql dba

1031

---

What is sql profiling in oracle?

1039

---

What is the difference between a primary key and a unique key?

1042

---

Is nosql relational?

924

---