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;

What are the different types of triggers?

1136

---

what is myisam? : Sql dba

1084

---

how to run 'mysql' commands from a batch file? : Sql dba

1120

---

How do you create an update query?

962

---

What is the difference between cross join and natural join?

1022

---

Is a view faster than a stored procedure?

970

---

Does view contain data?

1034

---

Which sql statement is used to delete data from a database?

957

---

which types of join is used in sql widely? : Sql dba

982

---

What are the different types of a subquery?

1048

---

define data blocks ? : Sql dba

996

---

what is the difference difference between procedure and packages

10407

---

How is use pl and sql?

1059

---

What do you mean by query optimization?

1002

---

How do you modify a column in sql?

997

---