Retrieve case sensitive tables

  • Thread starter Thread starter abbeyro
  • Start date Start date
A

abbeyro

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
 
Which method are you using? I don't know the answer off of the top of my
head but I would be glad to play around with it - just curious about how
you're getting it - are you using the GetSchema or similar method or
querying the system catalogs?
 
Which method are you using? I don't know the answer off of the top of my
head but I would be glad to play around with it - just curious about how
you're getting it - are you using the GetSchema or similar method or
querying the system catalogs?
Click to expand...

Hi William, thanks for replying.
I'm using the following query: SELECT * FROM all_tables

Executing the query from Oracle's command line I obtain: my/table
From .NET: MY/TABLE

And the table was created as "my/table" to make it case sensitive and
enable to support the slash.

Thanks.
 
Back
Top