RE: Upper Case retrieval of Data - Possible ?

  • From: "Mark W. Farnham" <mwf@xxxxxxxx>
  • To: <VIVEK_SHARMA@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 27 Jun 2006 06:56:27 -0400

If you want all upper without modifying the existing queries, you create a
view. Of course the real table will need to be renamed first if you really
want to avoid modifying the code at all (so that the current name in the
query is available as the name for the view.)

What part of SQL*Server destroys the uppercase-lowercase distinction? In
case I ever have to use that database I want to know. That may be even more
information content destructive than confusing the zero length string with a
NULL value.



-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Sent: Tuesday, June 27, 2006 5:58 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Upper Case retrieval of Data - Possible ?

As part of porting an Application from SQL*Server to Oracle, when using
SQL/PLSQL etc we need to retrieve Data in UPPER Case "Database-wide"
irrespective of Case of storage of data within the field of Table/Index.

Wish to Avoid specifying UPPER Clause in the where Query.

NOTE - Data may be stored in Upper or Lower Case in Different fields of the

NOTE - In the Previous T-SQL Code on SQL*Server the UPPER Clause was NOT

Is it possible?

Target Oracle ver = 9.2

**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely
for the use of the addressee(s). If you are not the intended recipient,
please notify the sender by e-mail and delete the original message. Further,
you are not to copy, disclose, or distribute this e-mail or its contents to
any other person and any such actions are unlawful. This e-mail may contain
viruses. Infosys has taken every reasonable precaution to minimize this
risk, but is not liable for any damage you may sustain as a result of any
virus in this e-mail. You should carry out your own virus checks before
opening the e-mail or attachment. Infosys reserves the right to monitor and
review the content of all messages sent to or from this e-mail address.
Messages sent to or from this e-mail address may be stored on the Infosys
e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***

Other related posts: