Re: varchar2 case insensitive
From: Jomarlen <jomarlen_at_aol.com>
Date: 1997/09/25
Message-ID: <19970925204501.QAA01872_at_ladder01.news.aol.com>#1/1
Date: 1997/09/25
Message-ID: <19970925204501.QAA01872_at_ladder01.news.aol.com>#1/1
>
>I am desiginig a table and I need a column of type varchar2 to be not
>case sensitive for index on that column. I have looked through the
>documentation, and I can't find out where I can specify case sensitivity
>
>to be NO. Can you please help me.
>
You can't specify case when creating a column. What yo can do is use a trigger to force the value to upper case
Example for column description in table material
CREATE OR REPLACE TRIGGER material_trg
BEFORE INSERT OR UPDATE
ON material
FOR EACH ROW
BEGIN
:new.description := upper(:new.description);
END;
Received on Thu Sep 25 1997 - 00:00:00 CEST