| Database trigger [message #3034] |
Sun, 01 September 2002 01:38  |
Deepak DCunha
Messages: 1
Registered: September 2002
|
Junior Member |
|
|
Could you please give me the solution for the following.
I wanna write a trigger which avoids any transaction on Sunday.
|
|
|
|
| Re: Database trigger [message #3043 is a reply to message #3034] |
Sun, 01 September 2002 23:58  |
Puneet Vats
Messages: 33
Registered: June 2002
|
Member |
|
|
Dear,
So easy,
declare
v_day varchar(90);
begin
select to_char(sysdate,'dy') into v_day from dual;
if v_day = 'sun' then
raise_application_error(-20200,'this is sunday');
end if;
end;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
