Retrieve case sensitive tables

Hello,

I'm trying to retrieve a list of tables from all_tables in a given
Oracle db. I'm using System.Data.OracleClient 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
.

Relevant Pages

  • Re: the 20% rule
    ... The fastest way to retrieve rows from a table is to access the row ... query that you use often, ... configuration variables, such as shared global memory areas, cached ... With Oracle, it is generally best to rely on tools like explain ...
    (comp.databases.theory)
  • Re: How to get meta data info in ADO.NET
    ... Database Schema from MS SQL Server and Oracle. ... can successfully retrieve all the tables and columns from the database. ... How can i identify which columns are primary key or foreign key? ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Oracle adapter issue in BizTalk
    ... And are you using BizTalk 2006 Server with Oracle ... How can I retrieve multiple records using oracle adapter? ... My procedure in the package returns ref courser. ... I want to retrieve multiples record from table using procedure. ...
    (microsoft.public.biztalk.general)
  • Issue with references and array slice with one member !
    ... Recently I faced one scenario with references and array slice in perl. ... I used following program to retrieve the rows from a table in Oracle using ... Connect to the database and return a database handle ...
    (perl.beginners)
  • Re: Capturing returned ODBC error message using form_Error
    ... > I have written an application with an Access front end to an Oracle ... > All security and data validation is in the Oracle database, ... Is there any way I can retrieve this message during ...
    (microsoft.public.access.externaldata)