Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS (DY)';
CREATE TABLE "site" (x) AS
SELECT 1 FROM DUAL;
1 rows affected

SELECT COUNT(*) FROM "SITE";
ORA-00942: table or view does not exist

SELECT COUNT(*) FROM SITE;
ORA-00942: table or view does not exist

SELECT COUNT(*) FROM "site";

COUNT(*)

1

CREATE TABLE "NUMBER" (x) AS
SELECT 1 FROM DUAL;
1 rows affected

SELECT COUNT(*) FROM NUMBER;
ORA-00903: invalid table name

SELECT COUNT(*) FROM "NUMBER";

COUNT(*)

1

SELECT owner, table_name FROM all_tables WHERE UPPER(table_name) = 'SITE';

OWNER
TABLE_NAME

FIDDLE_MBPNYPSMHICIRTAOJVEM
site