Click here to Skip to main content
Click here to Skip to main content

Tagged as

Check Constraint to validate a Financial Year in Oracle

, 23 Jul 2010 CPOL
Rate this:
Please Sign up or sign in to vote.
Check Constraint to validate a Financial Year in Oracle
When a situation arises to check a financial year like 200910, 201011, 201112 is in correct format, here is small tip to enforce a check constraint on a column in Oracle.
FinYear int check (finyear = floor(finyear/100)*100 + ( floor(finyear/100)-(floor(finyear/10000)*100)+1))
 
This will ensure that the input data is a valid financial year in format like YYYYyy (200910, 201011 ...).
 
This can be extended to any other database or language simply replacing floor function with appropriate language specific floor function. In most of the situations, floor function is directly supported by all major languages and databases.
 
Happy coding...

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Ravi LVS

India India
No Biography provided

Comments and Discussions

 
-- There are no messages in this forum --
| Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.1411023.1 | Last Updated 23 Jul 2010
Article Copyright 2010 by Ravi LVS
Everything else Copyright © CodeProject, 1999-2014
Layout: fixed | fluid