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;

Is json a nosql?

723

---

how do you know if your mysql server is alive? : Sql dba

778

---

Can a view be mutating? If yes, then how?

751

---

What is pl sql code?

751

---

What is set serveroutput on?

842

---

---

What is the use of double ampersand (&&) in sql queries? Give an example

810

---

Can we join 3 tables in sql?

705

---

What is the maximum number of rows in sql table?

741

---

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

733

---

What are the qualities of 2nf?

747

---

What is trigger with example?

736

---

Explian rowid, rownum?

751

---

What is varchar used for?

748

---

what is the different between now() and current_date()? : Sql dba

701

---

What is difference between sql and mysql?

747

---