If you have object names in lower case, use " around the name:
SELECT * FROM "your_table";
This is also the way to create (and drop) objects in lower case.
CREATE TABLE "tab"
( col NUMBER
);
DROP TABLE "tab";
As fas as i know tables migrated from Access can get created in lower case.




Reply With Quote