Answer / 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;

Answer / 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 is 'mysqldump'? : Sql dba

0 Answers  

---

what is transaction? : Sql dba

0 Answers  

---

Begin For j in 4403201000 .. 4403202000 Loop If mod (j, 100) = 0 then Dbms_output.put_line (j); End if; End loop; End; what will be the output of this question

7 Answers   TCS,

---

Is sqlite good enough for production?

0 Answers  

---

What is the maximum number of triggers,can apply to a single table?

2 Answers  

---

what are set operators in sql? : Sql dba

0 Answers  

---

What is Histogram?

0 Answers   NIIT,

---

What does select * from mean in sql?

0 Answers  

---

using subquery how can i calculate working days in a month?

3 Answers   Spice Telecom,

---

what is the different between unique+not null & primary key,

4 Answers  

---

What are the types of optimization?

0 Answers  

---

difference between SQL and C

1 Answers   Indus Software Technologies,

---