From: kennedy-downwithspammersfamily@attbi.net   
      
   "Madjid Nasiri"  wrote in message   
   news:251d9fce.0401310019.44c81569@posting.google.com...   
   > Walt  wrote in message   
   news:<401A8A37.D644F684@boatnerd.com.invalid>...   
   > > Guido Konsolke wrote:   
   > > >   
   > > > "Madjid Nasiri" wrote...   
   > > > > Hi,   
   > > > > I am basic in oracle. My Old programs write with Delphi and   
   > >  Databases:   
   > > > > Access, Paradox, MySQL, Microsoft SQL.   
   > > > > I write my code (SQL code) case-insensitivae, but now i need use   
   > > > > oracle database. The Oracle by default is case-sensitive, How can   
   > >  used   
   > > > > case-insensitive in oracle.   
   > > > >   
   > > > > Thanks   
   > > > > Madjid Nasiri   
   > > >   
   > > > Hi Madjid,   
   > > >   
   > > > I hope you are going to use a version >= 8.1.7 (9.2.0.4 would be   
   > > > best).   
   > > > Since you don't provide much infos to play around with, here are 2 two   
   > > > possible meanings of your post:   
   > > > 1. You want to store data case insensitive: do an 'insert...   
   > > > values(upper('Abcd'))...'.   
   > > > This will put your data in upper case into the tables.   
   > > > 2. Your data will be mixed-case and you want to select them case   
   > > > insensitive:   
   > > > create 'function based indexes' on every column you want to use in   
   > > > your where-clauses.   
   > > > Then 'select ... where  = 'ABCD'.   
   > > >   
   > > > If my assumptions about your intention are wrong, please explain it a   
   > > > little.   
   > >   
   > > Sounds to me like a third possibility:   
   > >   
   > > 3.  He has a body of SQL that is case-insensitive and mistakenly   
   > > believes that Oracle SQL is case sensitive.   
   > >   
   > > Majid,   
   > >   
   > > Oracle SQL is case insensitive.  The character data stored in Oracle is   
   > > case sensitive.   
   > >   
   > > i.e. the following statements are identical:   
   > >   SELECT * from FOO where COL = 'BAR';   
   > >   select * From Foo WHERE col = 'BAR';   
   > >   
   > > These two are not:   
   > >   SELECT * from FOO where COL = 'BAR';   
   > >   SELECT * from FOO where COL = 'Bar';   
   > >   
   > > Oracle provides string functions UPPER() and LOWER() to deal with   
   > > case-sensitivity issues.  There's also INITCAP() but it doesn't always   
   > > give you what you want.   
   >   
   > Hi All, and Thanks from Guido and Walt   
   > I didn't problam with Data case-sensitive. My problam is in "Table   
   > Name" and "Field Name" for example I like   
   > select Table1.Code from Table1 ======== select TABLE1.CODE from TABLE1   
   >   
   > Thanks for answers,   
   > Madjid   
      
   Don't do that.  It is going to drive you nuts.  Usually people get mixed   
   case table and column names when they export an Acess database or another   
   database via ODBC to Oracle.  The tool will quote all the table and column   
   names and thus make them mixed case. Which means you have to type select   
   "myColumnOne","myColumnTwo" from "myTable" where "myColumnOne"=5;   
   Jim   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)