Results 1 to 3 of 3

Thread: Trigger problem

Threaded View

  1. 11-10-2005, 02:37 PM #1
    182
    182 is offline Registered User
    Join Date
    Dec 2004
    Posts
    37

    Trigger problem

    Hey guys, i am trying to create a trigger that won't allow a table to be upddated on monday or tuesday. Can anyone tell me whats wrong with the code I have done for this?

    Thanks

    IF TO_CHAR(sysdate, 'dy') 'mon'|| 'tue' THEN
    RAISE_APPLICATION_ERROR(-2015, 'error');
    ENDIF
    Last edited by 182; 11-10-2005 at 10:39 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules