Newbie to oracle database

I am using oracle9i. I create two tables in sqlplus with the following script:

--script start
create table test001(gnuid numeric);

create table "test002"(gnuid numeric);
--script end

the screen show that the tables are successfully created. Then when i try select the tables, the screen show "table or view not exist" for table test002, but the test001 is okay, return "no row selected".

Why this happen?

just try using,

select * from "test002"
/

If you use double quotes, Oracle will be case sensitiv when you select from that table (which complies with the ANSI SQL standard).

Don't use quotes and you'll be fine

>> just try using, select * from "test002"

Yes, this works.


>> Don't use quotes and you'll be fine

If quotes is not used, then the table name will be uppercased after creation. How to preserve the lower case for table name if i dont want to use quotes?

Thanks for all the reply.

What's so important about the case of the table name. You are right, that if you don't use quotes, it will internally be stored in upper case.
So what?

Even if it is stored in upper case internally, you can use lower case table names, so where is the problem?

I am new to oracle. I have some experience in MySQL...
If a table named C01CUSTPROFILE is created in MySQL, and the OS is linux, then this query:

select * from C01CUSTPROFILE will return data or no data.

select * from c01custprofile will return a error from JDBC, a "unknown source error".

However this only happen in linux, in windows is ok.

I dont know whether this will apply to oracle in linux enviroment or not. I want to try this but unfortunately, there is limited resource(what i have is only oracle in windows).

Pls advise.