Date check constraint
I'm a beginner using databases and currently working on my first database script where i'm trying to add different check constraints. I've looked around but can't seem to find any way to add a check to a date, which checks if the inserted row with a given date is older than the day it was created. Is this even possible or is there a easy why to add this?
Using Oracle DB.
Thanks in advance!
I've not encountered a constraint setup like that.
A pre-insert trigger might be the only solution, if you want to keep it in the db rather than checking beforehand in Java.