Question

Using oracle sql for creating database nd inserting data

I want to write a constraint on the date of birth so that any age will be only be from 21 to 60

This constraint should be calculated automatically using sysdate or the system date

Hint: data type is date

Also for the car year model I want to write a constraint to check that it is not older than 10 years (the field data type is integer) I want it using sysdate coz it wil be used for long time

Answer 1

For checking date constraint you have to create table with check condition on date of birth. To calculate age you can use sysdate() or getdate() function and find the difference between date of birth and sytem date (current date) then apply condition for age between 21 to 60.

You have to write a query like this to create table..

create table employee (empid number(5), name varchar(20),birthdate date check (DATEDIFF(year,birthdate,getdate()) >=21 and DATEDIFF(year,birthdate,getdate()) <=60 ))

  

Note: You can use sysdate() or getdate().

Like check condition on age, you can use check condition for car model also.

Like this

create table car (carid number(5), model varchar(20),purchasedate date check (DATEDIFF(year,purchasedate,getdate()) <=10))