Home » SQL & PL/SQL » SQL & PL/SQL » sysdate and check constraints
sysdate and check constraints [message #7043] Sat, 17 May 2003 04:50 Go to next message
Neena
Messages: 2
Registered: December 2001
Junior Member
i want to create a table with a check constraint that will check whether the date in that field is greater than or equal to the sysdate .i cannot use sysdate in the check constraint .is there ny other option ?................a.s.a.p;

neena
Re: sysdate and check constraints [message #7044 is a reply to message #7043] Sat, 17 May 2003 05:18 Go to previous message
Barbara Boehmer
Messages: 9077
Registered: November 2002
Location: California, USA
Senior Member
Use a before insert row trigger.
Previous Topic: Creating files in remote directory in UNIX using UTL_FILE
Next Topic: 01034 -oracle not available ???? urgent
Goto Forum:
  


Current Time: Fri Mar 29 04:10:21 CDT 2024