Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Uppercase lower case issue..

627047May 12 2009 — edited May 12 2009
I am fiinding this throughout all the oracle stuff.
If I create a view or stored procedure, it always returns the column names in uppercase...
This is an issue, becuase some of my code uses keys in grids that are case sensitive.
And my app has to work with both MS SQL and Oracle..
So the view listed below, returns the column names in uppercase instead of the case I have specified..
Is there any way around this?

SELECT View_AssetCurrent.AssetID,
View_AssetCurrent.ItemVar1 ,
View_AssetCurrent.ItemVar2 ,
View_AssetCurrent.ItemVar3 ,
View_AssetCurrent.ItemVar4 ,
View_AssetCurrent.ItemVar5 ,
View_AssetCurrent.ItemVar6 ,
View_AssetCurrent.ItemVar7 ,
View_AssetCurrent.ItemVar8 ,
View_AssetCurrent.ItemVar9 , View_AssetCurrent.ItemVar10 ,
View_AssetCurrent.ItemVar11 ,
View_AssetCurrent.ItemVar12 ,
View_AssetCurrent.ItemVar13 ,
View_AssetCurrent.ItemVar14 ,
View_AssetCurrent.ItemVar15 ,
View_AssetCurrent.ItemVar16 ,
View_AssetCurrent.ItemVar17 ,
View_AssetCurrent.ItemVar18 ,
View_AssetCurrent.ItemVar19 ,
View_AssetCurrent.ItemVar20 ,
View_AssetCurrent.AssetDate , View_AssetCurrent.ProfileID , View_AssetCurrent.Carrier ,
View_AssetCurrent.CurrentID ,
View_AssetCurrent.DestinationID ,
View_AssetCurrent.OwnerID ,
View_AssetCurrent.IntraUserName ,
View_AssetCurrent.ClientName ,
View_AssetCurrent.HDate ,
View_AssetCurrent.HStatus ,
View_AssetCurrent.HParent ,
View_AssetCurrent.HVar1 ,
View_AssetCurrent.HVar2 ,
View_AssetCurrent.HVar3 , View_AssetCurrent.HVar4 ,
View_AssetCurrent.HVar5 ,
View_AssetCurrent.HVar6 ,
View_AssetCurrent.HVar7 ,
View_AssetCurrent.HVar8 ,
View_AssetCurrent.HVar9 ,
View_AssetCurrent.HVar10 ,
View_AssetCurrent.SignatureID ,
View_AssetCurrent.ImageID ,
View_AssetCurrent.UpdatedByParent ,
View_AssetCurrent.ExplicitOwnerID ,
View_AssetCurrent.ExplicitDestID ,
View_RecipAndLoc_All.EmpID ,
View_RecipAndLoc_All.FullName ,
View_RecipAndLoc_All.RecipVar1 ,
View_RecipAndLoc_All.RecipVar2 ,
View_RecipAndLoc_All.RecipVar3 ,
View_RecipAndLoc_All.RecipVar4 ,
View_RecipAndLoc_All.RecipVar5 ,
View_RecipAndLoc_All.RecipVar6 ,
View_RecipAndLoc_All.RecipVar7 ,
View_RecipAndLoc_All.RecipVar8 ,
View_RecipAndLoc_All.RecipVar9 ,
View_RecipAndLoc_All.RecipVar10 ,
View_RecipAndLoc_All.DYNAMIC ,
View_RecipAndLoc_All.Download ,
View_RecipAndLoc_All.STATUS ,
View_RecipAndLoc_All.LastModified ,
View_RecipAndLoc_All.EmailAddress ,
ClientList.Client_Type ,
RTRIM(f_getRecipName(View_AssetCurrent.CurrentID, View_AssetCurrent.ProfileID)) CurrentName,
RTRIM(f_getRecipName(View_AssetCurrent.DestinationID, View_AssetCurrent.ProfileID)) DestinationName ,
RTRIM(f_getRecipName(View_AssetCurrent.OwnerID, View_AssetCurrent.ProfileID)) OwnerName ,
Signatures.Sig_Data "Sig_Data"
FROM View_AssetCurrent
LEFT JOIN Signatures
ON View_AssetCurrent.SignatureID = Signatures.Sig_ID
LEFT JOIN ClientList
ON View_AssetCurrent.ClientName = ClientList.Client_Name
LEFT JOIN View_RecipAndLoc_All
ON View_AssetCurrent.ProfileID = View_RecipAndLoc_All.ProfileID
AND View_AssetCurrent.DestinationID = View_RecipAndLoc_All.EmpID
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 9 2009
Added on May 12 2009
13 comments
2,083 views