Case sensitive issue
I'm in the process of updating all of the sql scripts that were previously done by another worker. I was instructed to follow a format where I would be capitalizing all the scripts. I have already started this process and I realized that this might be an issue. What is the best way to test if the db i'm running against is case sensitive?
Currently when I try running
select * from tbluser - this select statement returns the columns but each column is fully expanded in Oracle sql developer
select * from TBLUSER - this select statement returns the columns but each column is small and doesn't show the entire column contents in Oracle sql developer
Before I go too deep in these changes I want to make sure there will be no issues.
Thank you