SQL Language (MOSC)

MOSC Banner

Case Insensitive Searches

edited Jun 6, 2013 7:58PM in SQL Language (MOSC) 3 commentsAnswered

Please note that i have read Note 1025420.6 (but per application developer, we've got this code in a 10g application and it doesn't work in 11g (both instances on same server running Windows 2003 Server 32 bit))

Note that in 11g the result being picked up is NOT leading edge of string.

sqlplus user/pwd@SID                                                            
                                                                                
SQL*Plus: Release 10.2.0.5.0 - Production on Mon Mar 25 14:38:12 2013           
                                                                                
Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.                         
                                                                                
Connected to:                                                                   
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production          
With the Partitioning, OLAP, Data Mining and Real Application Testing options   
                                                                                
SQL> desc people                                                                
 Name                                      Null?    Type                        
 ----------------------------------------- -------- ----------------------------
                                                                                
 ID                                                  NUMBER(1)                   
 FIRSTNAME                                          NVARCHAR2(20)               

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center