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;

What are the parts of a sql statement?

555

---

What is normalization in a database?

614

---

Define concurrency control. : Transact sql

587

---

How to load data with sql*loader?

552

---

What are the two characteristics of a primary key?

493

---

---

How many rows can sqlite handle?

587

---

Can we create index on primary key?

524

---

What are inbuilt functions in sql?

602

---

What are properties of the transaction?

560

---

How do you write a subquery?

523

---

what is csv? : Sql dba

578

---

What are the types of functions in sql?

569

---

How do you write an inner join query?

517

---

What is the cause of mutating table error and how can we solve it?

602

---

Can I learn sql in a week?

554

---