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;