Retrieve case sensitive tables
From: <abbeyro_at_gmail.com>
Date: Mon, 7 Jan 2008 09:27:53 -0800 (PST)
Message-ID: <1b8a5fee-6b83-4a71-9a4c-4aee8ffc5e47@s19g2000prg.googlegroups.com>
Date: Mon, 7 Jan 2008 09:27:53 -0800 (PST)
Message-ID: <1b8a5fee-6b83-4a71-9a4c-4aee8ffc5e47@s19g2000prg.googlegroups.com>
Hello,
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?
Thank-you.
Abbeyro
Received on Mon Jan 07 2008 - 11:27:53 CST