Answer Posted / 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;

What plvcmt and plvrb does in pl/sql?

1366

---

How do I write a sql query in pgadmin 4?

1046

---

Explain the commit statement.

1215

---

What is parameter substitution in sql?

1081

---

What is memory optimized?

1135

---

What is an exception in PL/SQL? What are the two types of exceptions?

1402

---

Why we use pl sql?

1009

---

Can we create a trigger on view?

946

---

what is the difference between blob and text? : Sql dba

1064

---

How do you use collections in procedure to return the resultset?

2286

---

what is isam? : Sql dba

1068

---

How do I view a view in sql?

996

---

What is the use of & in pl sql?

1099

---

What company owns postgresql?

1092

---

what is a join? : Sql dba

1086

---