Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

mode uppercase database

SOLVED
Go to solution
Adrian_72
Advisor

mode uppercase database

Do you know if is posible configure a oracle database in character mode uppercase?

I need store all informacion in the database with uppercase letter.
Is supported this.

Thank you my friend's.
4 REPLIES
Volker Borowski
Honored Contributor
Solution

Re: mode uppercase database

Hi,

as far as I know it is not.

But you can configure the tables you create with constraints that will permit only upercase letters and let the application that fills in data take care about the conversion.

Option two would be to create triggers for inserts and updates to your tables, that do the conversion automaticly.

Hope this helps
Volker
Adrian_72
Advisor

Re: mode uppercase database

Do you know any technical note
Sanjay Kumar Suri
Honored Contributor

Re: mode uppercase database

Not possible.

However one can user UPPER function while carrying out DML operations.

sks
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
Yogeeraj_1
Honored Contributor

Re: mode uppercase database

hi,

me too don't think this will be possible.

But you can do it the hard way, by writing triggers on each table, for example:

create trigger emp_trigger
after insert or update on emp for each row
begin
:new.upper_ename := upper(:new.ename);
end;
/

will try search for other easy ways for such conversions.

good luck
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)