mode uppercase database

[Adrian_72]

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.

[Volker Borowski · Accepted solution]

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]

Do you know any technical note

[Sanjay Kumar Suri]

Not possible.

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

sks

[Yogeeraj_1]

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