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 are the different types of constraints?

1273

---

What is a full join sql?

1102

---

How to combine two stored procedures in sql?

1321

---

Is it possible to create startup or shutdown trigger for on-schema?

1090

---

what are the properties and different types of sub-queries? : Sql dba

1072

---

What is the purpose of cursors in pl/sql?

1200

---

Define SQL and state the differences between SQL and other conventional programming Languages?

1261

---

Can we use rowid as primary key?

1041

---

how do you control the max size of a heap table? : Sql dba

1022

---

Explain correlated query work?

1100

---

What packages(if any) has oracle provided for use by developers?

5877

---

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

1056

---

what is a table in a database ? : Sql dba

1088

---

How do I debug a stored procedure?

1161

---

What is a temporal table?

978

---