Answer / debasish sinha

create or replace trigger trg_sun
before insert on <table name>
begin
if rtrim(to_char(sysdate,'day'))=rtrim('sunday') then
raise_application_error(-20345,'no transaction in sunday');
end if;
end trg_sun;

Answer / 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 will default fire first  statement level trigger or row level trigger

2 Answers   Cap Gemini, Data Vision,

---

Are sql database names case sensitive?

0 Answers  

---

What kind of join is join?

0 Answers  

---

How many postgresql users are there, worldwide?

0 Answers  

---

Explain the difference between rename and alias?

0 Answers  

---

Whis is not false in primary key?

0 Answers   Fintellix,

---

What are sql indexes?

0 Answers  

---

What is before and after trigger?

0 Answers  

---

What is a sql schema used for?

0 Answers  

---

What is not in sql?

0 Answers  

---

what is a database lock ? : Sql dba

0 Answers  

---

What are the steps you take to tune(performance tuning) the code in plsql?

4 Answers   Cap Gemini, Infosys, TCS,

---