ORA-01747: invalid user.table.column, table.column, or column specification
create table tq84_t(a number, b number);
update
tq84_t
set
a = 1, -- Note the comma
where
b=2
;
update
tq84_t
set
option = 7 -- option is a keyword, see v$reserved_words
where
b=2
;
select
t..a -- Note the double-dot
from
tq84_t t
Where
t.b = 42
;
select
count(t.*) -- Note the alias in the aggregate function
from
tq84_t t;
v$tempseg_usage has a column with the reserved name USER, thus, the following query throws ORA-01747: invalid user.table.column, table.column, or column specification: