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;

Write a query to get 2nd maximum salary in an employee table ?

69 Answers   Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP,

---

What is the difference between anonymous block and named block or stored procedure?

8 Answers  

---

How can a function retun more than one value in oracle with proper example?

0 Answers  

---

Why do we need databases?

0 Answers  

---

explain advantages of myisam over innodb? : Sql dba

0 Answers  

---

Explain sql data types?

0 Answers  

---

What are the 3 modes of parameter?

0 Answers  

---

Is sql the best database?

0 Answers  

---

Why are aggregate functions called so?

0 Answers  

---

What are the different types of dbmss?

0 Answers  

---

What is a record in pl/sql?

0 Answers  

---

How many types of indexes are there in sql?

0 Answers  

---