nasiri@kawacomputer.com (Madjid Nasiri) wrote in message news:<251d9fce.0401310019.44c81569@posting.google. com>...[color=blue]
> Walt <walt@boatnerd.com.invalid> wrote in message news:<401A8A37.D644F684@boatnerd.com.invalid>...[color=green]
> > Guido Konsolke wrote:[color=darkred]
> > >
> > > "Madjid Nasiri" wrote...
> > > > Hi,
> > > > I am basic in oracle. My Old programs write with Delphi and[/color][/color]
> Databases:[color=green][color=darkred]
> > > > 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[/color][/color]
> used[color=green][color=darkred]
> > > > 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 <column_name> = 'ABCD'.
> > >
> > > If my assumptions about your intention are wrong, please explain it a
> > > little.[/color]
> >
> > 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.[/color]
>
> 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,[/color]
Hi Madjid,
as long as you enclose your db-objects not with "<object>" you will
have no problems. If you enclose your objects, you have to enclose
your querys-objects also. for example :
################################################## ###############
SQL> create table foo (blah number);
Table created.
SQL> select * from foo;
no rows selected
SQL> select * from "foo";
select * from "foo"
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> create table "foo" (blah number);
Table created.
SQL> select * from foo;
no rows selected
SQL> insert into "foo" values (8);
1 row created.
SQL> select * from foo;
no rows selected
SQL> select * from "foo";
BLAH
----------
8
SQL>
################################################## #####
regards
s.kapitza
