Home » SQL & PL/SQL » SQL & PL/SQL » database trigger (plsql)
database trigger [message #360143] Wed, 19 November 2008 14:31 Go to next message
daniel.deepu
Messages: 2
Registered: November 2008
Junior Member
How to enforce a database trigger which can update a table only from monday to friday from 9am to 5pm
Re: database trigger [message #360144 is a reply to message #360143] Wed, 19 November 2008 14:40 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Simply by writing it.

Post what you tried,, we don't do homework for you.

Before Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and use code tags.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

For instance, read
Database Application Developer's Guide - Fundamentals
Chapter 9 Coding Triggers

Regards
Michel
Previous Topic: Create HTML with htp.formOpen
Next Topic: DateTime Query Problem
Goto Forum:
  


Current Time: Fri Dec 09 13:58:37 CST 2016

Total time taken to generate the page: 0.17903 seconds