Re: Retrieve case sensitive tables

On 07.01.2008 18:27, abbeyro_at_gmail.com wrote:
> I'm trying to retrieve a list of tables from all_tables in a given
> Oracle db. I'm using the .NET provider (by Microsoft) and I always
> obtain the results in uppercase. The problem is that some tables where
> defined in "Mixed/Case" so when I retrieve the list I need to obtain
> the exact case used when they were created. Do you know how can I
> achieve this?

Adding to Ken's reply: there is also a slight chance that your .NET provider changes case, e.g. if you use some metadata facility. You could try to directly query USER_TABLES to see the table names.

Kind regards

        robert Received on Mon Jan 07 2008 - 12:26:35 CST