Oracle add multiple fields at the same time-case ____oracle

Operations Database: Oracle 10g

There are times when there is a need to add multiple fields to an Oracle database, as follows:

ALTER TABLE My_workflow
Add (State varchar2 (2) Default ' 0 ' not null,name varchar2 (MB) not null,age number default 0 not NULL);

The above statement explains:

Table Name: My_workflow

3 fields were added:

Field 1: Field name: State, Data type: VARCHAR2 (2), default value ' 0 ', NOT NULL

Field 2: Field Name: Name, data type: VARCHAR2 (100), not empty (not NULL)

Field 3: Field name: Age, data type number, default value 0, NOT NULL