query about check constraint [closed]

by

Since you are using Oracle you can use CHECK constraint saying 

CONSTRAINT check_dates
  CHECK (my_date_column BETWEEN date '1994-10-25' AND date '2016-05-10')

Your query (as in comment) should be like below

 create table dob5 ( birthdate date not null, 
                    CONSTRAINT check_dates 
                    CHECK (birthdate BETWEEN date '1994-10-25' AND date '2016-05-10') );

See this demo fiddle http://sqlfiddle.com/#!4/779f9

More Related Contents:

  1. SQL Query to concatenate column values from multiple rows in Oracle
  2. Select First Row of Every Group in sql [duplicate]
  3. Paging with Oracle
  4. Comparing Dates in Oracle SQL
  5. Oracle Differences between NVL and Coalesce
  6. Oracle SQL query: Retrieve latest values per group based on time [duplicate]
  7. SQL – How to store and navigate hierarchies?
  8. GROUP BY / aggregate function confusion in SQL
  9. Oracle “(+)” Operator
  10. How do you create a temporary table in an Oracle database?
  11. Calculating difference between two timestamps in Oracle in milliseconds
  12. How can I find which tables reference a given table in Oracle SQL Developer?
  13. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  14. How to check the maximum number of allowed connections to an Oracle database?
  15. Oracle equivalent of Postgres’ DISTINCT ON?
  16. How to get the last row of an Oracle table
  17. Select without a FROM clause in Oracle
  18. Is there any way to flush output from PL/SQL in Oracle?
  19. What is the difference between ‘YYYY’ and ‘RRRR’ in Oracle SQL
  20. Oracle – How to create a materialized view with FAST REFRESH and JOINS
  21. PLSQL Insert into with subquery and returning clause
  22. SELECT from table with Varying IN list in WHERE clause
  23. How to populate calendar table in Oracle?
  24. Does Oracle use short-circuit evaluation?
  25. Oracle 11g – Check constraint with RegEx
  26. Advice Using Pivot Table in Oracle
  27. ORACLE SQL:Get all integers between two numbers
  28. The network adapter could not establish the connection – Oracle 11g
  29. Local Temporary table in Oracle 10 (for the scope of Stored Procedure)
  30. Oracle: function based index selective uniqueness

Leave a Comment