Unable to alter column name

Question

I am unable to alter column name in oracle 12c

Below is my Table structure :-

ORDER_ID                                  NOT NULL NUMBER(38)
RX_IMAGE1                                 NOT NULL BLOB
RX_IMAGE3                                 NOT NULL BLOB
RX_IMAGE4                                 NOT NULL BLOB
CREATE_DATE_TIME                          NOT NULL DATE
LAST_UPDATE_DATE_TIME                     NOT NULL DATE
RX_IMAGE2                                 NOT NULL BLOB

I want to change RX_IMAGE1 "not null" to "null"

Answer 1

You are not changing the data type (and cannot do so), so remove that from the command:

SQL> ALTER TABLE PRESCRIPTION_IMAGES MODIFY RX_IMAGE3 NULL; 

Table altered.

db<>fiddle