Search notes:
ORA-01735: invalid ALTER TABLE option
create table tq84_t (a number);
The following statement throws ORA-01735: invalid ALTER TABLE option:
alter table tq84_t a not null;
This statement is better:
alter table tq84_t modify a not null;
Cleaning up:
drop table tq84_t;