metadata gettables()

From: Jeff Kish (jeff.kish_at_mro.com)
Date: 02/23/05 

Date: Wed, 23 Feb 2005 13:21:19 -0500

DatabaseMetaData.getTables(null, schemaName.toUpperCase(), "%", types);

I find that if I don't supply this in upper case, on Oracle 9.2, it does not
work.
So, I'm guessing this is all vendor dependant.

does Oracle always need these folded to upper case, and what about other db's.
I guess you can install ms sql server either to be case sensitive or case
insensitive - what is the best way to check for a certain table then?

I guess I'm not sure if this is a problem.. I mean the user creates the
schema's.. I don't know if it is a problem if they enter mixed/lower/upper
case for schema names.

Thanks for clarifying my mentally muddy waters.

Jeff Kish

Relevant Pages

  • Re: Function based index!
    ... Oracle usually doesn't use indexes when functions are used on fields. ... Another solution is to store the data in uppercase and to modify the ... clause sometimes is forced to use upper case. ... enterprise edition? ...
    (comp.databases.oracle.server)
  • Function based index!
    ... clause sometimes is forced to use upper case. ... (criteria may also be "where some_field like 'abc%'.....") ... where one is an upper case index so Oracle always ... enterprise edition? ...
    (comp.databases.oracle.server)
  • Re: 10g Memory Usage: 12 GB RAM & 5000 Connections ~ Need help understanding
    ... I'd recommend to use no more than 75% of physical memory as an upper ... other Oracle channels about how much we could give Oracle and still ...
    (comp.databases.oracle.server)
  • Re: 10g Memory Usage: 12 GB RAM & 5000 Connections ~ Need help understanding
    ... I'd recommend to use no more than 75% of physical memory as an upper ... other Oracle channels about how much we could give Oracle and still ...
    (comp.databases.oracle.server)
  • Pana CT30WX52 service menu - need help decoding
    ... I got into the service menu and see hex data like this. ... guessing that the upper 2 bytes is the default? ... Does this sound ...
    (sci.electronics.repair)