topic mode uppercase database in Operating System - HP-UX

mode uppercase database

Adrian_72 — Fri, 30 Jul 2004 10:27:52 GMT

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.

Re: mode uppercase database

Volker Borowski — Fri, 30 Jul 2004 11:10:56 GMT

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

Re: mode uppercase database

Adrian_72 — Fri, 30 Jul 2004 11:14:18 GMT

Do you know any technical note

Re: mode uppercase database

Sanjay Kumar Suri — Fri, 30 Jul 2004 17:30:45 GMT

Not possible.

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

sks

Re: mode uppercase database

Yogeeraj_1 — Sat, 31 Jul 2004 05:14:13 GMT

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