Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Case sensitive issue

jerry8989Sep 26 2011 — edited Sep 26 2011
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
This post has been answered by JustinCave on Sep 26 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 24 2011
Added on Sep 26 2011
9 comments
4,620 views