Home » RDBMS Server » Server Administration » Table Definition and Data problem
Table Definition and Data problem [message #369239] Mon, 24 July 2000 18:39 Go to next message
Suresh.N
Messages: 41
Registered: March 2000
Member
Hi,

I want to clarify about one doubt.

I konw very well Oracle Records ie Data is Case sensitive.

Like

"suresh" and "SURESH" are differnent. right?

I have one table called Test(Name Varcahr2(10));

I have given the primary key .

I have entered two record like

suresh and SURESH.

Ok.

I want to implement the Record are not case sensitive.

If i insert record like 'suresh' first it should not to allow to enter 'SURESH'.

I don not want to user Upper case or Lower case functions.

Is there any possible to do like this ?

Can u suggest me.

Thanks
Suresh.N
Re: Table Definition and Data problem [message #369244 is a reply to message #369239] Tue, 25 July 2000 19:22 Go to previous messageGo to next message
Sam
Messages: 255
Registered: April 2000
Senior Member
Hey R U getting any idea from triggers...for case in-sensitive search....function based indexes

hope it will help
sam
Re: Table Definition and Data problem [message #369259 is a reply to message #369239] Thu, 27 July 2000 17:40 Go to previous message
Suresh
Messages: 189
Registered: December 1998
Senior Member
Hi,

Thanks for Reply.
I came to know somthing called short order in sql server.That means the date whether upper case or lower case is same.
I want to know whether the concept is avilable in oracle.

Thanks
Suresh
Previous Topic: Table Definition and Data problem
Next Topic: ideal buffer cache hit ratio
Goto Forum:
  


Current Time: Fri Mar 29 06:50:13 CDT 2024