Re: Oracle tablename problem

Mavis Hearnden (M.A.Hearnden_at_lut.ac.uk) wrote:
: A user on our system has been using Visual Basic on a PC together
: with SQL*Net to access Oracle data (Oracle v6.0.37..
: on an HP 9000/8??) .
: The program he wrote created Oracle tables which had names including lower
: case letters. (eg zone, Products).
: When he tried to access these tables, he couldn't.
: Trying to rename/drop them didn't work either.
You can force case sensitivity for data dictionary objects by enclosing the object name in double quotes - e.g. : create table "Dual" ("T" char(1));

The problem is that you will have to use the same techinque for all other DML or DDL statements, - e.g.

   select "T" from "Dual";
or

   drop table "Dual";

As you saw the sql parser will automatically convert the names to uppercase. I don't have any exp. w/ VB, but the user's code may use quotes in his strings or VB does this before passing the sql string to sqlnet.

hth,
Phil Fielder
Los Alamos Nat. Lab Received on Wed Feb 15 1995 - 04:51:51 CET