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;

how to convert character strings to dates? : Sql dba

985

---

how to fetch alternate records from a table? : Sql dba

1053

---

Explain what is table in a database?

1009

---

What is snowflake sql?

1013

---

Explain the difference in execution of triggers and stored procedures?

969

---

Explain the rollback statement?

964

---

How do you write an inner join query?

892

---

Why is there a need for sqlcode and sqlerrm variables?

999

---

how to load data files into tables with 'mysqlimport'? : Sql dba

1034

---

what is the difference between a web-garden and a web-farm? : Sql dba

1012

---

Can we use join in subquery?

1023

---

What are sql procedures?

967

---

What is the use of function "module procedure" in pl/sql?

1136

---

how is exception handling handled in mysql? : Sql dba

1009

---

What is pl/sql table? Why it is used?

991

---