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 fetch alternate records from a table?

671

---

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

495

---

What is difference between sql and excel?

508

---

Does google use sql?

504

---

What is cte?

564

---

---

What is pivot query?

588

---

Is primary key clustered or nonclustered?

552

---

what is 'mysqlcheck'? : Sql dba

563

---

Is primary key clustered index?

510

---

What is the difference between pl and sql?

535

---

Is big data nosql?

505

---

What is the difference between jpql and sql?

544

---

Is sql harder than python?

600

---

What is difference between db2 and sql?

522

---

How is a process of pl/sql compiled?

589

---