Re: Column names

No. If possible, I would do one of the following.

1. Rename the tables and columns in MS Access to be uppercase and re-export them to Oracle.
2. Get a DBA tool to reverse engineer your Oracle database and change all the generated DDL to be uppercase.
3. Write a script to recreate all your tables with uppercase names (don't forget about indexes and constraints!)
4. Create views that give uppercase names to everything (create view ACCOUNTS as select "accountID" ACCOUNT_ID,... FROM "accounts")

Good luck,
Matt

Torben Nyman Nielsen wrote in message <7jj1b3$ahj$1_at_news.inet.tele.dk>...
>Hi all,
>
>I have several tables unloaded from ACCESS. Unfortunately the column names
>is in lower case when they are inserted in Oracle 8. Is there a way to
>convert the column names in a table to UPPER case ???
>
>Best regards
>Torben Nyman Nielsen
>Allise - Denmark
>
>
Received on Tue Jun 08 1999 - 18:05:48 CDT