How does oracle modify the length of multiple fields at once?

alter table TB_EXAM_PROBLEM modify  PRO_DESC VARCHAR2(4000);alter table TB_EXAM_PROBLEM modify  PRO_KEY VARCHAR2(4000);

can only be modified one by one?

Jan.22,2022

alter table TB_EXAM_PROBLEM modify PRO_DESC VARCHAR2(4000),
modify PRO_KEY VARCHAR2(4000);

Mysql supports an alter statement to modify multiple fields. Separate the different modify with and .

 

did not understand the problem of the landlord, what is meant by "can only be modified one by one"?

whether you write an alter statement per line of fields, or you reply to modify multiple fields in an alter statement, it's just a command.
if you want to modify multiple fields, put all the command statements to be executed in a sql file, and then execute them in batches.

Menu