ORA-00903: invalid table name

Table name missing after LEFT JOIN

A scenario that provokes ORA-00903: invalid table name is an SQL statement where the name of a table is missing (forgotten) after a left join clause.

Create two test tables:

create table tq84_A (id number);
create table tq84_B (id number);

The following (invalid) SQL statement throws ORA-00903: invalid table name:

select
   *
from
   tq84_A a                left join
   tq84_B b on a.id = b.id left join
where
   a.id = 4;

Cleaning up:

drop   table tq84_A;
drop   table tq84_B;

Compare this error with ORA-00923: FROM keyword not found where expected.

RENAME TABLE x TO y

Unlike the truncate table statement, the rename statement does not require the object type (i. e. table) and the following statement also throws ORA-00903: invalid table name:

rename table x to y;

Better:

rename x to y;

ORA-00903: invalid table name

Table name missing after LEFT JOIN

RENAME TABLE x TO y

See also