Answer Posted / 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;
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
How can I get the number of records affected by a stored procedure?
What steps server process has to take to execute an update statement?
What is the mutating table and constraining table?
Are pl sql variables case sensitive?
What is sql indexing?
What is insert command in sql?
What is the plv (pl/vision) package offers?
Why are aggregate functions called so?
what are sequences
Why do we go for stored procedures?
Explain scalar functions in sql?
How does left join work in sql?
What are crud methods?
Which one is better subquery or joins?
What is indexing in sql and its types?
