table with name "order" : invalid table name

Question

I understand why. I know, this name is really not valid. But this table exists in my DB. I can't rename it. I have no permission. But, may be, there is a some choice for me? How can I execute something like

select COUNT(*) from "order";

? Thanks.

Obs: Thanks for all, problem resolved.

Answer 1

Oracle stores table names in upper case, so you need:

SELECT count(*) 
FROM "ORDER"

Answer 2

This works for me in Oracle

create table "order" (c1 number);

Table created.

select COUNT(*) from "order"

COUNT(*) 0