Assuming that you mean you want to make all string data case insensitive and that the requirement has come from developers who don't want to check their inputs for case errors (though I bet they want to say business logic is an application function) then a check constraint on each column that the inserted/updated value is equal to its uppercase representation is a start. Then they'll have to either check for the constraint failing or start discussions with you about database input validation aka constraints. On 7/20/09, Roger Xu <wellmetus@xxxxxxxxx> wrote: > Hi List, > > I have read the following but I am looking for a way to create a > case-insensitive database. Is it even possible? > > http://askanantha.blogspot.com/2007/07/making-oracle-case-insensitive.html > > Thanks, > > Roger Xu > -- Sent from Google Mail for mobile | mobile.google.com Niall Litchfield Oracle DBA http://www.orawin.info -- //www.freelists.org/webpage/oracle-l