Home » SQL & PL/SQL » SQL & PL/SQL » Re: Database trigger
Re: Database trigger [message #3052] Mon, 02 September 2002 12:57
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
It's not clear from the question whether the trigger should stop all transactions in the database, all transactions in a schema, or transactions on a certain table(s), but the body of the trigger is even simpler than the other example given (no variables are needed and no select from dual is needed):

if to_char(sysdate, 'Dy') = 'Sun' then
  raise_application_error(-20000, 'Transactions not allowed on Sunday');
end if;

Report message to a moderator

Previous Topic: 2 tables, different formats, extract to csv.
Next Topic: Explicit Cursors with Variables
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 08 04:20:32 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.