Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Please can anyone help me with SQL in Oracle.

Please can anyone help me with SQL in Oracle.

From: Ray <raytao_at_home.com>
Date: 2000/02/01
Message-ID: <38967653.11734066@news>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US