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 clustered and non-clustered indexes?

4 Answers   Microsoft,

---

what is the difference between primary key and unique key? : Sql dba

0 Answers  

---

There are 5 records in a table and we have implemented two triggers that are :pre_query and post_query how many times these triggers will fire.

2 Answers   Maruti Suzuki,

---

What are analytic functions in sql?

0 Answers  

---

How many sql statements are used?

0 Answers  

---

How to find only %th Highest Sal

6 Answers   Infogain, Symphony,

---

How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,

---

ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.

1 Answers   Zensar,

---

What is bind variable in pl sql?

0 Answers  

---

Why do we need sharding?

0 Answers  

---

what is oracle database ? : Sql dba

0 Answers  

---

how to extract a unit value from a date and time? : Sql dba

0 Answers  

---