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 5 18437
"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 <column_name> = 'ABCD'.
If my assumptions about your intention are wrong, please explain it a
little.
hth,
Guido
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 <column_name> = '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.
--
//-Walt
//
// http://tinyurl.com/3xqyq
Walt <wa**@boatnerd.com.invalid> wrote in message news:<40***************@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 <column_name> = '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
"Madjid Nasiri" <na****@kawacomputer.com> wrote in message
news:25**************************@posting.google.c om... Walt <wa**@boatnerd.com.invalid> wrote in message
news:<40***************@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 <column_name> = '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 na****@kawacomputer.com (Madjid Nasiri) wrote in message news:<25**************************@posting.google. com>... Walt <wa**@boatnerd.com.invalid> wrote in message news:<40***************@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 <column_name> = '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,
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: T Tran via SQLMonster.com |
last post by:
Hi Gurus,
I'm a beginner. Would you please tell me if it's possible to create a view
having a calcuated column based on the condition of the column on the sql
table.
create view vwImaging AS...
|
by: Wolfgang Kreuzer |
last post by:
Hello all,
I have two tables - Projects and ProjectStruct
Table Projects contains master records of the projects, ProjectStruct
allows to define a project herarchie and contains the fields...
|
by: Kiyomi |
last post by:
Hello,
I create a Table1 dynamically at run time, and at the same time, I would
like to create LinkButton controls, also dynamically, and insert them into
each line in my Table1. I would...
|
by: Joe HM |
last post by:
Hello -
I have a Base Class where I want a New() implemented that can be called
from the outside. This New() should create an instance of the
appropriate cDerivedX Class ...
The following...
|
by: Angel Of Death |
last post by:
I have a method. It takes some XML as a parameter. Depending on the
content of the XML it should create a specific object and call a KNOWN
method.
So: public void PersistXml(string XmlData){}
...
|
by: sandy |
last post by:
I need (okay, I want) to make a dynamic array of my class 'Directory',
within my class Directory (Can you already smell disaster?)
Each Directory can have subdirectories so I thought to put these...
|
by: =?Utf-8?B?T2xkQnV0U3RpbGxMZWFybmluZw==?= |
last post by:
I want create an instance of an object which accepts a Data Reader as a
constructor. I realize that I could create a gigantic case statement in
which I test for each text name, but that case...
|
by: MaryamSh |
last post by:
Hi,
I am creating a Dynamic Search in my application.
I create a user control and in Page_load event I create a dynamic dropdownlist and 2 dynamic button (Add,Remove)
By pressing Add button...
|
by: MaryamSh |
last post by:
Create Dynamic Dropdownlist Controls and related event
--------------------------------------------------------------------------------
Hi,
I am creating a Dynamic Search in my application.
I...
|
by: Kerem Gümrükcü |
last post by:
Hi,
i try to create a remote process with Win32_Process.Create, but the remote
machine always retruns 9 as result, which say that the path could not be
found.
Code seems to be fine, except the...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |