Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Please can anyone help me with SQL in Oracle.
In the table I have created using Oracle 8 and SQL statements, I need to be able to check if a field called 'BIRTHDATE' of type 'DATE' is no more than 15 years from today. How can I code for this because I cannot use the SYSDATE system variable with the CREATE TABLE statement? I need to somehow check if this constraint is true. Should it be coded on the column level or table level? Does anyone know how I can do this? Any help would be great!!! Please email me at raytao_at_home.com if you have a solution. Thank you. Received on Tue Feb 01 2000 - 00:00:00 CST
![]() |
![]() |