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;

Define select, insert, create, delete, update, drop keywords

1049

---

Difference between truncate, delete and drop commands?

1082

---

Is nosql relational?

943

---

What are the different ways to optimize a sql query?

946

---

Why do you partition data?

1022

---

what is oltp (online transaction processing)? : Sql dba

1078

---

What is cursor explain with example?

987

---

How many postgresql users are there, worldwide?

1061

---

How to display the records between two range in Oracle SQL Plus?

1147

---

Is sql a oracle?

981

---

What are sql constraints?

1175

---

Is join and inner join the same?

1003

---

What does <> sql mean?

1091

---

How do you concatenate in sql?

1028

---

What are reports usually used for?

1023

---