Re: Mixed case Table/column names

Rich Nichols wrote:
> Does anybody know how to specify
> mxed case table/column names that will persist?

Enclose table and column names in double quotes e.g.
create table "Test"("Fld 1" date, "Fld2" date)create table "Test"("Fld 1" date, "Fld2" date)

As you can see, you can also embed spaces if you like.

The only snag with this approach is that you must ALWAYS reference the table in double quotes from then on;

eg.

SQL> desc test
Object does not exist.
SQL> desc "Test"

 Name                            Null?    Type
 ------------------------------- -------- ----
 Fld 1                                    DATE
 Fld2                                     DATE