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;

can i use global variables in stored procedure or function

1 Answers   L&T,

---

What are sql functions? Describe the different types of sql functions?

0 Answers  

---

Can one improve the performance of sql*loader? : aql loader

0 Answers  

---

What is a unique constraint?

0 Answers  

---

What is sql key?

0 Answers  

---

What does stand for in sql?

0 Answers  

---

how to load data files into tables with 'mysqlimport'? : Sql dba

0 Answers  

---

How exception handling is done in advance pl/sql?

0 Answers  

---

Why do we use partitions in sql?

0 Answers  

---

how to create temparary sequence

2 Answers   TCS,

---

explain primary keys and auto increment fields in mysql : sql dba

0 Answers  

---

What is the purpose of design view?

0 Answers  

---