Home » Infrastructure » Windows » Are table names case sensitive ? (stupid question)
Are table names case sensitive ? (stupid question) [message #100085] Mon, 15 July 2002 08:11 Go to next message
Francisco Mancardi
Messages: 1
Registered: July 2002
Junior Member
I'm working with oracle 8.1.7 on Windows 2000,
and when I issue a create table with table name
not on CAPITAL letters I've got no error, but
when I want to issue sql statements to the table
I've got errors.

any hint ???
Re: Are table names case sensitive ? (stupid question) [message #100089 is a reply to message #100085] Tue, 16 July 2002 04:59 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Nothing is really stupid, as Technology is concerned.
not everything is impossible and not everything is possible.
[b]case 1.[/b]

select * from emp
is same as
select * from EMP

[b]case 2.[/b]
but when u use table_name in where clause it should CAPS by defualt( becuase oracle stores it as such).

SQL> select * from cat where table_name='emp';

no rows selected

SQL> select * from cat where table_name='EMP';

TABLE_NAME                     TABLE_TYPE
------------------------------ -----------
EMP                            TABLE

[b]case 3:[/b]
under considerations (which is not recomended) u can create a table with small caps ie..emp.

SQL> create table "emp1" as select * from emp;

Table created.
SQL> select * from cat where table_name='emp1';

TABLE_NAME                     TABLE_TYPE
------------------------------ -----------
emp1                           TABLE

SQL> select * from cat where table_name='EMP1';

TABLE_NAME                     TABLE_TYPE
------------------------------ -----------
EMP1                           TABLE

Previous Topic: Oracle ODBC and Long Raw fields problems.
Next Topic: Re: Oracle 8 Personal Installation on WIN 2000 failure
Goto Forum:

Current Time: Sun Feb 25 02:58:29 CST 2024