SQL & PL/SQL

Hi all,

Apologies if this has been asked many times already:

Is it possible in Oracle to use mixed case table and column names (e.g. DataCollection, GenericData, AdminActivity) and at the same time being able access them in a case insensitive manner?

An example: Assume we have a table "Person" with a column "familyName". In MySQL5 I believe the following queries are equivalent:
select familyName from Person;
select familyname from Person;

However, the table names still seem to be case sensitive, so "select familyname from person;" will not work.

In Oracle I believe none of this is possible, not by default at least. The only way to do that query would be something like:
select "familyName" from "Person";

(The reason why I'm asking is that we have a database which I want to use as the source for generating a Java API, and I need/want the Java classes and attributes to be (automatically) created with mixed case names. At the same time we have existing applications and scripts that access the database, and these assume case insensitive table and column names.)

I realise this is probably not possible, but thought it would be worth asking. Please post anyway to confirm or deny or if you have any ideas!