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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Insert Data into a table in uppercase only

813146Apr 6 2011 — edited Apr 6 2011

Hello Oracle World,

We have a situation here. Just curious to find out if anyone of you have some excellent ideas...

- We have a table t1, to which data is being inserted from multiple systems. We would like to have the data to be inserted in uppercase only no matter which way the data is inserted.

- We do not want any changes in the sourcing system programs.

- We do not want to have any triggers on the table.

My Question is: Is there any way (some magical SQL command) to convert the data to uppercase before insert and put it in the table?

Please let me know if you need more information.

Thanks,
-Aditya.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 4 2011

Added on Apr 6 2011

#11g, #9i, #insert, #oracle, #sql

3 comments

3,535 views