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!

Column values in Caps

SK KFeb 21 2012 — edited Feb 21 2012

Hi All,

Database : 11g

Is it possible to store particular column value in Caps? if user issues insert statements with lower case, is there any way to store it in upper case by default?

I have searched if there is any column defaults available while creating table itself, but could not find any useful results.

Because it is impossible to predict whether user issues insert statement with value for column in lower case or upper case.
I do not have any application to control it.

Regards,

SK

This post has been answered by Frank Kulash on Feb 21 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 20 2012

Added on Feb 21 2012

6 comments

3,328 views