Answer Posted / rajdeep

create or replace trigger <trigger_name> before insert on <table_name>
begin
if (sysdate,'day') in 'sunday'
then
raise_application_error(-20500,'cannot insert values on sunday');
end if;
end;

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

924

---

What are different types of triggers?

1021

---

What is difference between stored procedures and application procedures?

955

---

How to revise and re-run the last sql command?

1095

---

How many commands are there in sql?

970

---

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

966

---

Are subqueries faster than joins?

945

---

Can sql function call stored procedure?

955

---

Can we call procedure in select statement?

968

---

What do you mean by query optimization?

949

---

What is sqlerrd?

918

---

What do you understand by pl/sql cursors?

1011

---

How would you reference column values before and after you have inserted and deleted triggers?

1014

---

How to avoid using cursors?

1035

---

How to avoid duplicate records in a query?

950

---