Re: Phantom Tables

Hi!

If the tablename is not in uppercase you have to use quotes.

This will drop the Table named EMP:
Drop Table Emp;

This will drop the Table named Emp, and not the table named EMP: Drop Table "Emp";

You get such tablenames if some bogus tool/script sends this SQL to Oracle:
Create Table "Emp";

Regards,
Nj l Received on Wed Jun 14 2000 - 00:00:00 CDT