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)