Need to get rid of a table with a mixed-case tablename

• Quoting Jeff Kopmanis to All dated 06-12-94 ***
  > One of our people created a table with MS Access on our Oracle7
  > database
  > (via ODBC) that has a name that is mixed-case. Oracle doesn't seem to
  > want
  > to touch it and MS Access doesn't let us do that via ODBC (that we can
  > tell). How do you either override Access's foolishness or tell Oracle
  > to
  > NOT convert our SQL strings into upper case so that we may delete the
  > table?
  

Use double-quotes around the mixed case -- i.e.

drop table "MS_Access";

will work just fine. Received on Sun Jun 12 1994 - 15:13:38 CEST